http://reddymsbitools.blogspot.com

Saturday, 26 February 2011

Automatically generate report in a specific format using SSRS

If you would like to generate a report in a specific format(html,pdf,xls, csv, xml) without having the user to select the format, use this technique:

PDF : http://localhost/ReportServer?CompanySales&rs:Command=Render&rs:Format=PDF

EXCEL: http://localhost/ReportServer?CompanySales&rs:Command=Render&rs:Format=Excel

With Parameters: Passing State and City as parameters

http://localhost/ReportServer?CompanySales&rs:Command=Render&rs:Format=PDF&State=CA&City=ALI

No comments:

Post a Comment