Different states of the reports


The reporting services has a set of terms for to describe each state in the lifecycle of a report…


Report definition

The extension for this file is .rdl and it is created in the report designer or report builder. It gives the details about the various entities held or referenced in that particular report. For e.g. data source connections, queries, expressions, parameters, images other elements. They are written in XML and follow the Report Definition Language (RDL) syntax.



Published reports

The next stage in the lifecycle is of publishing the .rdl file to the report server by deploying it on the server. One can save it through the report builder or upload it through the report manager or management studio. The report is stored in the report DB and managed on the server once it is published. The published reports can be accessed directly through the URL or report manager or even the SharePoint web parts. They are made secure using the role-based security model from the reporting services.

On the report builder can create and save the published reports or else they are read-only.



Rendered reports

This is the final processed report with the data and the formatting information. This is optimized for viewing in the HTML browser. Once can consume the rendered report by wither opening a published report from the server or subscribing to the report which would then be delivered in the various formats to a shared folder or through email. The supported formats are excel, XML, pdf, tiff, csv.

This entry was posted in Reporting Services. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s