November 4, 2011 at 4:34 am
I am able to hide rows in column if amount is = 0
But when the report is exported to excel. The excel shows the hidden rows. I want not to show when the report is being exported.
How to solve this?
Thanks
November 4, 2011 at 4:41 am
Change the way that you export the data. Instead of exporting all the data export only the data that you want to show. Never count on an external tool to hide the data that you don't want the users to see.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 4, 2011 at 5:01 am
So how can I do that? Shall I rebuild the query or SSRS can do that?
Thanks. 🙂
November 7, 2011 at 2:53 am
Hiding Rows doesn't work on exported items. But filteration works so its done 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply