Creating a new report using Report Builder 2.0
Posted by decipherinfosys on February 23, 2009
In one of our previous blog post, we had covered the new Report Builder that is available as a feature pack download of SQL Server 2008. In this post, we are going to look at how easy it is to create reports using that interface. For any report, you need to have a data source – so, let’s set that up first:
1) Set up a data source:
Let’s use the Table Wizard to set it up quickly. Clicking on the table icon and selecting the table wizard gives us the “New Table or Matrix” box as shown below:
Now, select new and you can configure a data source for the report. It’s pretty straight forward – and Advanced properties does have a few new additions which we will cover in an upcoming post.
2) Creating the query:
Once the data source has been specified, the next step is to create the query – if you have a query already, you can just paste it in by clicking on “Edit As Text” or you can for your query using the query builder. You can also import a rdl file using the Import option:
3) Layout of the data:
Once you are done with the query, the next step is to specify the layout of the data fields in terms of rows, columns grouping:
4) Layout and Style Selection:
The next step is to select a layout and the style for the report:
And in the next step, you select the style. Once that is done and you click on Finish, your report is now ready. You can save the report as a rdl file and then you can also execute it to see the results. There are different options available in the ribbon menu above to be able to zoom in and zoom out, export the report in different formats, navigate between the pages etc.
Now that we have created the report locally, we can also deploy it to a server – in order to do so, click on the left cornermost icon (looks like a database icon) and under it you will see an “Options” button. Click on it and you will get this dialog where you can set the different values:
This is just one way to deploy it. You can also chose to go to the Report Manager and then upload the report using the Upload File button on the toolbar. There are other ways of deploying reports as well that we have covered before when talking about SQL Server 2005 Reporting Services and those still apply.