Get an Edge with SQL Server 2005 Reporting Services

Next, right click on Reports in the Solution Explorer and select Add New Report, as shown in the figure below, to add a new report to the project using the Report Wizard.

Add New Report to Your Project

In the Report Wizard window, select the data source (in our case we have chosen pubs) from which you wish to obtain data for your report. Click Next to proceed.

Report Wizard (Select Data Source)

At this point, you will create a query to get the data for your report. For this report, suppose you want to list book titles and author information from the titles and authors tables in the pubs database. You can either use Query Builder or type the SQL string manually as shown in the figure below.

SELECT titles.*, authors.*
FROM titles INNER JOIN authors ON titles.pub_id = authors.pub_id

Creating a Query

After specifying the data fields, we need to work on formatting the report. Click Next to proceed.

The first screen prompts you to select the type of report you wish to create. Choose Tabular or Matrix as needed and click Next.

On the next screen, you need to choose how to group this data in the table. Highlight the fields that are available and click the Details button as shown in the figure below.


Pages: 1 2 3 4 5 6


No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |