Rendering Extension is part/component of Report Server that transforms report data and layout to device specific format.
There are seven rendering extensions are available in SQL Server Reporting Services.
- HTML
- Excel
- Word
- CSV or Text
- Image
- XML
http://ComputerName/ReportServer/Pages/ReportViewer.aspx?%2fReport&rs:Command=Render
rs:format
rs:format can be used in url to define in which format we would like to render our report. if I have a report with name Report and I would like to render in Excel, My URL will be like below
http://ComputerName/ReportServer/Pages/ReportViewer.aspx?%2fReport&rs:Command=Render&rs:format=Excel
for PDF
http://ComputerName/ReportServer/Pages/ReportViewer.aspx?%2fReport&rs:Command=Render&rs:format=PDF
if you would like to render in any above, you can change the rs:format=YourExtension
Passing Parameter values in URL
You can also pass the parameter in url if required. If my Report Name is SaleReport and it is using Param_Isactive ( Boolean type), I can use below url to render my report to TIF with parameter value =true.
http://ComputerName/ReportServer/Pages/ReportViewer.aspx?%2fSaleReport&rs:Command=Render&rs:format=Image&Param_IsActive=true
No comments:
Post a Comment