asked on

Prevent Drilldown Links when exporting an SSRS report to excel

I am using BIDS in a 2008 SQLR2 environment and trying to prevent the hyperlink from exporting when I save the report as an excel or a PDF.

I found some documents that gave this example to remove the hyper links, but I am not using a URL, but the GO TO REPORT feature and I dont see a way to enter this.

Any ideas how to prevent these links from exporting. Globally would be nice, but going to each link to modify would work too.

=IIF(Globals!RenderFormat.Name = “RPL” , “http://www.google.co.in/#hl=en&source=hp&q=” & Replace(Fields!EmailAddress.Value,”@”,”%40¿),NOTHING)

ValentinoV

I wrote an article on how you can do that: http://blog.hoegaerden.be/2011/01/18/ssrs-hideshow-items-dependant-on-export-format/

For Excel, the RenderFormat property is set to EXCEL.

Let me know if you have any additional question on that.

red_75116

ASKER

ValentinoV,

That is close to what I want, but I have a drilldown link and it exports the hyperlink to excel and i can't see how to turn that off using your blog.

I have an ACTION using Goto Report. Where can I make that not export the hyperlink when exporting to Excel and PDF.

Thanks!

ValentinoV

The drillthrough link is located in a textbox, right? Is it an option to hide that textbox when exporting to Excel? Or do you still want the text to appear, without it actually being a hyperlink?

red_75116

ASKER

I want the text to appear, but not have the hyperlink. the owner doesnt' want our customer who might see the excel to know our internal server names and any parameters that could be passed to the sub report.

thanks

red_75116

ASKER

I tried something like this in the expression box on the action, but it makes all the hyperlinks to stop working

=IIF(Globals!RenderFormat.Name = "EXCEL" , "Items_Purchased_by_Cus,",NOTHING)

ASKER CERTIFIED SOLUTION

ValentinoV

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial