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
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.
Second step is to add a report. The report itself is a xml file (extension RDL) where the report structure itself is defined.
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
At the end of the report definition, we see the meta data defined in the report and its structure
and the quick preview
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
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
And double check the Reportserver in your browser…
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)
Now we have a shared data set to be used with new reports sharing the same set of data
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
or a 3th report with a simple chart graph (using the same shared data set)
and the preview