Report Projects: A practical overview

Let’s go through SSRS project (Rp) to discover how it’s easy to create reports inside BIDS.

Data Source: we have the option to define an embedded datasource but it would be specific for the report; so it’s better to define first a shared datasource in the Rp; it would be easier to maintain and share among different reports.

As you can see from the img

Image

In the shared data source properties we define all the properties of the connection, in fact the data source can be seen as a container where to store source of data information.

Image

Second step is to add a report. The report itself is a xml file (extension RDL) where the report structure itself is defined.

Image

The Query Designer helps us to define the extraction query from the data with the available fields we can use in our report; we can categorize in 3 types:

  • Page = field grouped at page level
  • Group = field will divide data in groups
  • Details = detailed info for each row of th report

Image

 

At the end of the report definition, we see the meta data defined in the report and its structure

Image

and the quick preview

Image

Note the page reports the State, the titles are grouped by Publisher as we defined in the previous wizard.

The last step is refining the field format to get a better data presentation

Image

Easy and quick, now it’s time to publish the report on the server; first make sure to define the url of the reportserver where to publish

Image

And double check the Reportserver in your browser…

Image

Note> if you have any issue with the timeout you can deploy a single report (or change the config in the ssrs installation path)

 

Let’s add another report to the solution, this time use a shared data set, the concept is similar to the shared data source, with the advantage that different reports can share the field set to show (and each one could use a different layou… table, matrix, list)

Image

Now we have a shared data set to be used with new reports sharing the same set of data

Image

Addin an empty report is different from using the Report Wizard the only necessity is to select from the toolbox the report layout and then to drag and drop the fields on the report itself

Image

or a 3th report with a simple chart graph (using the same shared data set)

Image

and the preview

Image

 

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