Bind Reports to Data
- 2 minutes to read
Supported Data Sources
DevExpress Reporting allows you to bind reports to the following data sources:
- SQL Database
- XML File
- Entity Framework
- Business Object
- Excel File
- JSON Data
- MongoDB Instance
- Data Federation
- Standard .NET Data Providers
Specify a Data Source
Use one of the following approaches to specify a data source for a report:
Invoke the Report Wizard to design a report bound to a data source.
Use the Data Source Wizard to bind a report to a data source. Expand the Data Source property editor and click Add Report Data Source to run the Data Source Wizard.
You can do the following in the Report Wizard and Data Source Wizard:
- Bind the report to data providers, including SQL, Entity Framework, Excel and object data sources;
- Create master-detail relationships between data tables and views;
- Invoke the Query Builder to shape report data.
Do not include dots in the name of a data source. The report engine uses dots to separate the data source name from query names.
Reuse a Report’s Data Source
You can reuse a report’s data source in other reports.