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 |
|
scamper
Yak Posting Veteran
52 Posts |
 Posted - 2014-05-30 : 13:52:03
|
| In a ssrs 2008 report, the user will export data to PDF, excel, and CSV files. When the report is exported to excel or csv file, the user wants me to hide some tablixes. Thus can you show me code on how to export the reports to csv or excel file without and be able to hide a few tablixes? |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-06-02 : 14:57:23
|
| Do you mean worksheets?if so , worksheets have a property - Visible. You can manipulate this property, either through the interface or programatically , for example using powershell - this example shows you how to make it visible http://www.sqlserver-dba.com/2011/09/powershell-excel-charts-and-data-presentation.html , to make it visible , you'd use FalseJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
ssrs 2008 export to excel and csv files