dcsimg
June 18, 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.

By submitting your information, you agree that developer.com may send you developer offers via email, phone and text message, as well as email offers about other products and services that developer believes may be of interest to you. developer will process your information in accordance with the Quinstreet Privacy Policy.

Sitemap

×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date