Disable links in exported excel sql reporting services
Posted on 2006-10-26
We are using SSRS 2000, and normaly render the reports in HTML, which works fine.
Some of our reports use links within table cells to run other reports, which works well for reports controlled within an application, but.......
When a user exports a report to excel, the links in the table cells show the full URL of the linked report, which I need to remove.
How can I have links in the reports that work from within our application, when rendered in HTML, and have these same links removed/disabled is the reports is exported in any way.
I have tried differing options on the cell output, but these all still show the link when the report is exported.
Can I configure Excel reports to only show base cell data - formatted of course - and not additional options like "jump to " values ?