xtrareports-400950-web-reporting-end-user-report-designer-for-web-wizards-data-source-wizard-fullscreen-specify-data-source-settings-database.md
This page appears if you select Database on the start page.
Select an item from the data connection list.
For information on how to register data connections in your application, refer to the following help topics:
Select tables, views, or stored procedures to include them in a data source as separate queries.
Schema loading in Data Source Wizard is optimized – the schema is loaded on demand when nodes are expanded to display child elements. You can use the DevExpress.Analytics.Wizard.AutoQueryPreload function to load the entire schema at once.
Check specific data fields if needed:
To join multiple data tables and shape the data, click the Queries category plus button. You can now create queries in the invoked Query Builder:
If you enabled custom SQL queries, the plus button opens a context menu. You can choose to run the Query Builder or Custom SQL Editor.
Important
Enable custom SQL queries only if you trust your users and environment. Make sure that you provide secure query validation to protect your database. See General Security Considerations for more information.
Click the Edit button ( ) to customize a query. Click the Delete button ( ) to remove a query.
When you click Finish and close the wizard, the data source appears under the Data Sources node in the Report Explorer. The Field List shows the data source structure.
This step appears if you select two or more queries.
To create a master-detail relationship, click the master table’s plus button. Next, select the detail table in the list and connect the key fields.
After the wizard is completed, the Field List shows the master-detail hierarchy.
This step appears if you select a parameterized stored procedure or create a custom query.
Select a query and click the plus button to add a new parameter.
Click the Edit button ( ) to customize the parameter. Click the Delete button ( ) to remove it.
Use the following approaches to specify a parameter value:
Assign a static value
Provide a dynamic parameter value