Friday, May 20, 2005

A Reporting Services How-To

Here's my quick Reporting Services tip for the day:

Suppose that you have a chart (or full report) that you want to display on a web page as an image (i.e., within a portlet or web part). You can easily use URL Access to do that!

Consider the following IMG tag:

< img src="http://servername/ReportServer?
%2fMyReporting%2fChartExample&rs:Command=Render
&rs:Format=IMAGE&rc:OutputFormat=PNG" border="1"
>

Breaks down like:

http://servername/ReportServer?

The URLAccess URL.


%2fMyReporting%2fChartExample

This is the path and report name. Note that %2f is the URL escape character for a slash.


rs:Command=Render&rs:Format=IMAGE&rc:OutputFormat=PNG

Causes the report server to render the report as a PNG image.