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
- 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 use dots in the data source name since the report engine uses them to separate the names of different data items (data source, table, relation, field, etc.)
Reuse a Report's Data Source
You can reuse a report's data source in other reports.