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.
- Log on to Reporting services manager.
- Switch to Tile view
- Click on new data source. Supply correct SQL Server and Company Database info.
- Test connection
- 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.