Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 334
  • Last Modified:

Disable links in exported excel sql reporting services

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 ?

Thanks
0
andygadget
Asked:
andygadget
  • 2
1 Solution
 
dnsvhCommented:
Do you need to export to Excel?  You can always remove that option entirely if you want to.
0
 
andygadgetAuthor Commented:
Unfortunalty I do .
I need CSV, EXCEL, and PDF as output alternatives. All other formats have been removed from the config file to prevent the user selecting these formats.

0
 
chrismcCommented:
I can only suggest using two versions. 1 with the relevant export options removed but with the links in, the 2nd with the export options in but the links removed.

Cheers
Chris
0
 
andygadgetAuthor Commented:
Not ideal, but this does seem the only ways of taking out report links. I will need to remove the select export option from the report viewer itself, and generate my own export process, but I suppose this cannot be helped.
Thanks for trying !
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now