The data source is defined by the ConnectionString, RecordSource, and Filter properties. These regular report properties are set in the Property Window by clicking on the background area where there are no sections. The data source is defined when you use the New Report Wizard to create the report.
To change the data source for a report
In the Administrator, connect to the server, then click the Reports tab. You should be connected to the reports database.
Do one of the following:
Click the report that you want to modify, then click Edit Report.
Create a new report. (See Creating a Report with the Report Wizard for instructions.)
The report appears in the Report Designer.
View the report in Design mode .
Click the DataSource
icon . The Data Source tab of the New
Report dialog box appears.
Specify the ConnectionString and RecordSource properties, then click OK.