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 |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2013-12-13 : 18:21:11
|
| In an SSRS 2008 r2, I am going to have some selected colunmns set as invisibile while the ssrs 2008 r2 report is running. However when the report is exported only to excel and csv files, I want those invisible columns to be included in the export. Thus can you tell me and or show me in code how to add the selected invisible columns to only the CSV and excel exports? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-14 : 00:55:41
|
| make two versions one for excel csv with no invisible columns and other with your current column visibility properties.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-14 : 00:56:50
|
| Another way is to keep a single rdl and write an expression for hidden property of columns based on =Globals!RenderFormat.Name value------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-12-14 : 17:54:47
|
| same you should me code to use the same rdl? I do not understand why I would need separate rdls. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-16 : 04:05:13
|
quote:
Originally posted by jassie
same you should me code to use the same rdl? I do not understand why I would need separate rdls.
ok..in that case as suggested use expression based on =Globals!RenderFormat.Name------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
ssrs export to csv and excel only