SQL Server Reporting Services with using the Wizard
In this section, we will use the Report Wizard to build a report. Let's go through the following steps:
Open Business Intelligence Development Studio
Launch the report wizard
Create a shared data source
Design a query
Select a report type
Design a table
Choose the table layout
Complete the wizard
Open Business Intelligence Development Studio (BIDS) (Start --> Microsoft SQL server 2008 --> SQL server Business Intelligence studio
Click File --> New project --> Report Server Project Wizard. Give any name and location.
Once you click OK, you will be presented with the following screen.
Click Next. Now configure your connection string. I have chosen the type as 'Microsoft SQL server'.
The Data Source contains the information necessary to retrieve the data we pull in our report. Reporting Services can access data in relational databases, OLAP databases, and any other data source for which like an ODBC or OLE DB driver, etc.
When we create a Data Source, we can specify it as shared which means it can be used by any report in the same project. If a Data Source isn't shared, it means that its definition is stored inside the report and it cannot be shared with another report.
After launching the Report Wizard, you will be presented with the Select the Data Source dialog as shown below:
In this step, you need to enter the query for the data, that you need the SSRS report to be populated with. You can also use the query builder.
Click on query builder, and click on the right most top icon, to add tables
Select the necessary table, and verify your query, then click the (!) icon to see the result of the query after execution.
If everything looks good, click on Next
Click Next
Add the fields, as shown in the below screenshot.
Click next
Choose a style, and click next.
Choose a deployment location. It will be in the form (http://machinename/Reportserver)
Click Next
You can preview the report in Business Intelligence Development Studio.
Now, Right click the project , and click deploy.
After successfully deploying the project, open up IE, and hit http://machinename/reports
Click on your report to open it.
Congratulations! You have made your first SSRS report.
