Export to excel without Hyperlinks

Hi,

I need to export a report to Excel without Hyperlinks. My original HTML report needs hyperlinks. Is there any way out.

Regards

Spandan

No, you cannot perform renderer specific actions in your report.

The only option is to "cheat" the user by having 2 copies of your report one with the other without the links. The user runs report 1 which has a link to report2 labelled "Export to Excel". Report1 then feeds all parameter selction to Report2. You'll need to construct your URL manually to have it returned as an XLS. On the link select jump to URL and use this sort of expression:

Code Snippet

=Globals!ReportServerUrl + "?/Your+Subfolder/Your+Report+Name"
+ "&param1=" + Replace(Parameters!param1.Value, "&", "%26")
+ "&param2=" + Replace(Parameters!param2.Value, "&", "%26")
+ "&rs:Command=Render&rs:Format=Excel"