Friday, October 19, 2007

Parameter reporting services 2005 URL and export PDF

Acessing reports services 2005 using url with parameters can be tricky sometimes because we have to construct the URL to the page with the parameters we want, my advice is to make step by step,

"http://[server]/reportserver?MyReport&rs:Command=Render&rc:Toolbar=false&
rs:ClearSession=true&type=1&typename=account&id={E8F20C3B-0F40-DC11-90E5-001560A50A1D}"


Ok what i did here
i call the reports and use some parameter to make the filter with the name:
id
type
typename


this fields will be defined in the report by @ "where [field]=@id and [field]=@type and [field]=@typename
@id
@type
@typename


and if you want to export directly to a PDF file you will need to add the tag in the url
&rs:Format=PDF

Ok is done easy and fast way to export reports to pdf, and you dont need to preeview report...
Post a Comment