SQL Server Reporting Services: Getting Started

• 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).
• Post a comment
• Email Article
• Print Article
• Share Articles
  • Digg
  • del.icio.us
  • Slashdot
  • DZone
  • Reddit
  • StumbleUpon
  • Facebook
  • FriendFeed
  • Furl
  • Newsvine
  • Google
  • LinkedIn
  • MySpace
  • Technorati
  • Twitter
  • Windows Live
  • YahooBuzz



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