A FlexReport definition can include several data sources, which are accessible through C1FlexReport.DataSources collection. The data sources in this collection are identified by unique names. These data sources can be used as:
- Main data source: It is the main data source for a report. The main data source is specified by using C1FlexReport.DataSourceName property on the report. If the main data source is not specified (DataSourceName is empty or contains a name not found in the DataSources collection), C1FlexReport is rendered in unbound mode, containing a single instance of the Detail section.
- Data source for Parameters: It is the source of valid values for the report parameters (elements in the C1FlexReport.Parameters collection). The data source for parameters is specified using ReportParameter.AllowedValuesDefinition.Binding.DataSourceName property.
- Data source for Charts: It is the data source for the Chart field. The data source for charts is specified using ChartField.DataSource property.
The list of supported data source types in FlexReport are as follows:
- OLE DB
- ODBC
- XML
- Object in external assembly
- Microsoft SQL Server Compact Data Provider version 3.5 and 4.0
- SQLite
For backwards compatibility with C1Report, C1FlexReport has a DataSource property which points to DataSources[DataSourceName]. When a new C1FlexReport is created, a single element with the name 'Main' is added to its C1FlexReport.DataSources collection, and 'Main' is assigned to the C1FlexReport.DataSourceName property.
Note that in C1Report, Main data source is the only data source for the report.
See Also