Creating Data Sources for SSRS Reports

Creating Data Sources for SSRS Reports

For all SSRS reports exhibited at this site, the data source described below needs to be created first. Listed blow are steps on how to create a data source at SSRS Reports Manager.

  1. Log on to Reporting services manager.

    Report Manager

    Report Manager

  2. Switch to Tile view

    Tile view

    Tile view

  3. Data sources

    Data sources

  4. Click on new data source. Supply correct SQL Server and Company Database info.

    SSRS DATA SOURCE

    SSRS DATA SOURCE

  5. Test connection
  6. Click Apply and exit

Note: Every report listed on this site reads the “GP Company Database”  and uses “zReports” database to create temporary tables.  For this purpose create a empty database zReports. The SQL user account used to connect to SQL Server at this data source should have read rights on the GP Company database and write rights on the “zReports” database.

Cheers!
Sanjay