SSRS to excel with criteria(s)

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.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

SSRS to excel with criteria(s)

Author

Topic

infodemers
Posting Yak Master

183 Posts

Posted - 2013-07-19 : 08:28:18

Hi,

When I export to excel or to any other type, I wish to have the criteria's from the filters on a row above the report output.

Any idea?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-20 : 08:29:21

you need to add a table in your SSRS report and use expressions from parameters to print out the selected values

something like



row1: Parameters!param1.label     Parameters!param1.value

row2: Parameters!param2.label     Parameters!param2.value

..

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

infodemers
Posting Yak Master

183 Posts

Posted - 2013-07-22 : 14:16:35

Hi visakh16,

Thanks a lot for helping me with this!

Regards!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-23 : 01:06:06

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources