There are two ways to do this task.
1] using Report Viewer (this is the default way when you configured reporting service to SharePoint Integrated mode)
2] using HTML viewer (This is the most interesting way in SharePoint Integrated mode. I’m going to stick to this way mostly)
1.When you passing parameters to report viewer you have to follow this way.
nothing can be wrong with this except parameters displaying in right hand side pane, which i do not like.
You can use the HTML viewer to view the reports .
here is the way to view the report in HTML viewer.
Your Report Server Virtual Directory ? Full Path of Report (where report is deployed in SharePoint site)
Example — > http://Server1/ReportServer?http://server1/sites/Test/Reports/YearlyTrend.rdl
Using above example you can view the report in HTML viewer. When it comes to parameter passing just append the parameter names and values to end of the URL with rs:command=render.
You can pass multiple parameters using above format. Target report’s parameters affected by values that you passed in URL
Further Modifications …
This can be used in SSRS Report drill down. When you want to drill down report there is an option to set URL.
Simply can set the URL to target report using expression with available parameters. Following expression can use to pop up the target report in separate window.
After all most common seen problem is ‘&’ (ampersand) symbol cannot pass in URL. because most of the time parameter values contain ‘&’ symbol. See the following example.
Parameters!ReportParameter1.value containing a ‘&’ symbol but this cannot be passed. you can Replace the ‘&’ symbol with ‘%2526′ ( which is the url encoding of ‘&’)
Post any problems that you have regarding this. Any thoughts will be welcomed !