Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
developer101
Starting Member
6 Posts |
 Posted - 2011-11-04 : 07:28:49
|
| I am able to hide rows in column if amount is = 0But 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 |
|
|
developer101
Starting Member
6 Posts |
Posted - 2011-11-07 : 05:05:05
|
quote:
Originally posted by developer101
I am able to hide rows in column if amount is = 0But 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
Hiding Rows doesn't work on exported items. But filteration works so its done :) |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-07 : 06:16:31
|
quote:
Originally posted by developer101
quote:
Originally posted by developer101
I am able to hide rows in column if amount is = 0But 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
Hiding Rows doesn't work on exported items. But filteration works so its done :)
yeah thats trueRendering SSRS reports in some other format will not support quite a bit of features available while rendering in native format------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Hiding rows SSRS