SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 ssrs export to csv and excel only
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jassie
Constraint Violating Yak Guru

308 Posts

Posted - 12/13/2013 :  18:21:11  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 12/14/2013 :  00:55:41  Show Profile  Reply with Quote
make two versions one for excel csv with no invisible columns and other with your current column visibility properties.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 12/14/2013 :  00:56:50  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

jassie
Constraint Violating Yak Guru

308 Posts

Posted - 12/14/2013 :  17:54:47  Show Profile  Reply with Quote
same you should me code to use the same rdl? I do not understand why I would need separate rdls.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 12/16/2013 :  04:05:13  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000