We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Disable links in exported excel sql reporting services

andygadget
andygadget asked
on
Medium Priority
345 Views
Last Modified: 2008-01-16
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
Comment
Watch Question

Commented:
Do you need to export to Excel?  You can always remove that option entirely if you want to.

Author

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.

BI & Database Architect & Developer, Sitecore Developer
CERTIFIED EXPERT
Commented:
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

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 !
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.