SQL Server Reporting Services: Getting Started

November 14, 2007
By Vikas Goyal

Click 'New Data Source' to set up the link with the database that will be used as the data source for the generated report.

Click here for a larger image.

Figure 4: Setting up Data Source

Once Data Source has been set up, go to the details page of Data Source and Generate Model for the Data Source.
Once Data Source has been set up and Model has been generated successfully, the Report Manager home will have two entries, as shown in Figure 5:

Click here for a larger image.

Figure 5: Report Manager

The next step is to design the report.
Click on 'Report Builder'. It will launch a new application that provides a workspace for designing the report using the Data Model generated above (see Figure 6).

Click here for a larger image.

Figure 6: Report Builder Workspace

Select the Model generated above and click 'OK'.
For this walkthrough, the sample database used has only one table. It has the following structure:

Click here for a larger image.

Figure 7: Data Structure

0 Comments (click to add your comment)

Comment and Contribute

Solid State Drives: The Future of Data Storage?

Solid state disks (SSDs) made a splash in consumer technology, and now the technology has its eyes on the enterprise storage market. Download this eBook to see what SSDs can do for your infrastructure and review the pros and cons of this potentially game-changing storage technology.