How to change a report column's visibility when the report is exported to Excel?
Is there some OnExport or OnPrint event or property that can be used to toggle a column's visibility when User wants to download the report to Excel?HomeCookN
September 11th, 2011 3:35pm
Hi,
Am afraid what you are looking for is not possible out of the box thought you can try some work-arounds.
Please go through these links -
http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/1012a7dc-ad8a-431c-a138-54a173e31016/
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/b67cb044-9d4a-470b-bf91-c863c3f8aec9/
Free Windows Admin Tool Kit Click here and download it now
September 11th, 2011 8:27pm
Wow: pretty surprising. I would have thought this was a pretty common bit of functionality. Anyway, thanks a lot for the workaround, Shahfaisal.HomeCookN
September 12th, 2011 11:57am