dcsimg
December 12, 2018
Hot Topics:

SQL Server Reporting Services: Getting Started

  • November 14, 2007
  • By Vikas Goyal
  • Send Email »
  • More Articles »
  • 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





Page 3 of 4



Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 


Enterprise Development Update

Don't miss an article. Subscribe to our newsletter below.

Sitemap

Thanks for your registration, follow us on our social networks to keep up-to-date