Before you can create and run reports, you must establish the source of your data by pointing the SSRS server to your SQL server. 

1. From within your institution folder, accessed via the web, click New Data Source on the main menu.
2. The New Data Source screen displays. Enter the necessary information and click OK.
3. Click Test Connection if you want to test the server connection first.
4. You are now ready to create and run reports.

The "Connection String" Field

When pointing to a production version of SQL Server, the connection string format is:

Data Source=123.123.123.123;Initial Catalog=AresData

The "Connect Using" Options

When the report server connects to the data source, it is using the read-only account you created to access the data.

Click Credentials stored securely in the report server and enter that Username and Password.

Understanding Data Sources and Datasets

Opening one of the default reports, for example, Reserve Items by Instructor, you will notice that the Report Data column on the left side of the form includes entries for Data Sources and DataSets. If you are hosted, these entries have been configured for you by Atlas Systems. The data source is the connection to your database. All reports must have a data source entry. Datasets are the saved queries that have been created for a saved report based off of the data source.

When you create new reports, you will configure your data source and dataset information for that particular report. Report Builder comes with a built-in library of information to assist you with creating reports. See Report Builder Help Documentation, below, for further information.