The General page of the Report DataSource smart panel is where you can set the Name, Type and Connection string of a new data source, or choose to use a shared data source reference.
You must always set the Name field for any data source to a unique name within the report.
If the Shared Reference checkbox is not selected, you can set the Type of the data source you want to use.
Data Dynamics Reports supports nearly any data source. Here are some of the more common ones that you can find under Type:
- Microsoft SQL Client Provider
- DataSet Provider
- Microsoft ODBC Provider
- Microsoft OleDB Provider
- Object Provider
- Oracle Client Provider
- XML Provider
If you select a Type value of SQL, OleDB, or Oracle, there are icons under Connection for three pages. (The other types have only a Connection String page.)
If the Shared Reference checkbox is selected, you can choose the shared data source you want by clicking the Browse button. Once you have chosen a shared data source, the Edit button to access the Shared Data Source becomes available.
You can also elect to execute datasets that use this data source in a single transaction by checking the Use Single Transaction checkbox.