Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 336
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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