Data Source Properties Window

The Data Source Properties window allows you to view or override the properties of a report data source (database connection).

You can reach this window from the Data Sources tab of the Report Properties panel in the Project Editor, or from the Logins page of the Command Line Builder.

When you first load a report, this window will show the connection settings that are stored in the report. To use those settings, you do not need to make any changes here.

If you need to run the report with different login information than the default, or connect to a different database, make the changes here.

You can override the report to connect to a different database of the same kind as was originally used in the report. For example, if you report was developed against your "Development" database in SQL Server, you can override the report to connect to the "Production" database in SQL Server instead.

However, you cannot use the override to connect to a different kind of database. For example, you cannot override the report to connect to an Oracle database instead of the original SQL Server database.

Settings

Connection Information

Shows the database connection information. You can override the server name/ODBC alias, database name, and/or schema name. Note that not all fields will be applicable for all database types.

If you want to connect using the same settings that are already stored in the report, you do not need to supply this information.

Click the Reset link next to a setting to reset that value to the default value configured in the report.

This field can contain variables and functions that are replaced at runtime. More... Click the {} button to display the text editor, which helps you insert variables and functions into the text. When you hover your mouse pointer over the field for a second, a preview of the "expanded" text will be displayed so you can confirm your variables and functions are working correctly.

Login Information

Shows the database login credentials. Check the Use integrated security box to use automatic authentication (if supported by the database) or uncheck the box and enter the user ID and password to use when connecting.