CODEWITHSUNDEEP
reporting-services
san
san

Reputation:

Can we hide or delete report rows in SSRS report while we render it to excel?

Is it possible to delete or hide a particular row in a table item just in excel rendering of the report. I have a summary report , which has a link to its detail report(drill through), when i export the summary report to excel i would like to delete the row with link becasue it wont work from excel . any idea?

Thanks for your time. San

Upvotes: 1

Views: 2297

Answers (3)

DForck42
DForck42

Reputation: 20327

if your users know that they want to export to excel/csv, you could just create a new report without the links, but a link on the summary report to the new report you jsut created, and have them export from there.

Upvotes: 0

CodeMonkey1313
CodeMonkey1313

Reputation: 16011

I would agree with Josh. In short there isn't an easy way to do it. You could potentially write and install your own plug-in to use instead of the excel output, but this would be pretty time intensive.

Upvotes: 1

JoshBerke
JoshBerke

Reputation: 67068

If your going to export to CSV you could set the DataElementOutput to none. I don't think there is any easy to do this to hide the report in excel. One thing you can try is to make the URL work. I bet the report is using the internal name of the server. There should be a way to configure ssrs to use a FQDN.

Upvotes: 1

Related Questions