Clever Geek Handbook

Reporting Services .. How to export an Excel spreadsheet with hyperlinks disabled

I am using the ReportViewer control to display the report in WebForm, I also implemented the Export to Excel function by calling the Render method of the server report

eg,

ReportViewerControl.ServerReport.Render("Excel",etc,etc,etc);

My problem is that the exported report contains hyperlinks that link to other reports, I want them to be displayed in the web form but not displayed, so they were disabled in the exported spreadsheet (generated by the code above).

Does anyone have a way to achieve this?

thank

+1


source to share


2 answers


To answer my own question, we ended up passing in an extra report parameter, and the report removed the links, and then called rendering as usual.



Simple, but it worked.

0


source


The report does not know in advance what form it will take upon export. If you need different layouts depending on the format the report is exported to, you need to make separate reports for each of these layouts.



0


source






More articles:


All Articles