Thursday, June 16, 2005

Ongoing Quest for Ways to Integrate Reporting Services with Portals

I played around some more with the HTML renderer in reporting services, and found a combination of parameters that would be most useful for portal integration:


http://server/ReportServer?%2fsamples%2fsample
&rs:Command=Render&rs:Format=HTML3.2&rc:HTMLFragment=true
This causes HTML 3.2 output to be generated, and only a fragment (not complete HTML).

The result is that you'll get a [table] with your report in it. Use whatever method you can to place this in your portlet.

An interesting side effect for multiple-page reports: You'll get a continuously rendered report with [hr /] between each page unless you include a "rc:Section=1" parameter (which will then only show the first page).