Report Workshop includes the following data provider components working with TRVReportGenerator.
Universal Data Providers
TRVReportBindSourceDataProvider (Delphi XE3 or newer) [VCL, FMX]
Access to: data via LiveBindings
Supported types of data queries: names associated with TBaseObjectBindSource- or TBindSourceAdapter-based components
TRVReportDBDataProvider
Access to: any data via TDataSet-based components
Supported types of data queries: names associated with TDataSet-based components
Data Providers Based on Standard Delphi Components
TRVReportADODataProvider [VCL]
Access to: multiple data stores accessed via ADO (ActiveX Data Objects)
Based on components: dbGo components by Borland/CodeGear/Embarcadero (TADOQuery and TADOTable)
Supported types of data queries: SQL or table name
TRVReportBDEDataProvider [VCL]
Access to: multiple databases accessed via BDE (Borland Database Engine), including Paradox, dBASE, FoxPro, Access, databases via ODBC, and others
Based on components: BDE components by Borland/CodeGear/Embarcadero (TQuery and TTable), available in Delphi and C++Builder prior to XE8.
Supported types of data queries: SQL or table name
TRVReportDBXDataProvider [VCL, FMX]
Access to: multiple databases via dbExpress drivers, including Oracle, Firebird, InterBase, DB2, Informix, SQL Server, MySQL and ODBC.
Based on components: dbExpress components by Borland/CodeGear/Embarcadero (TSQLQuery and TSQLTable)
Supported types of data queries: SQL or table name
TRVReportFDDataProvider [VCL, FMX]
Access to: multiple databases via FireDAC
Based on components: FireDAC components by Embarcadero (TFDQuery and TFDTable), available since RAD Studio XE3
Supported types of data queries: SQL or table name
TRVReportFDMongoDataProvider [VCL, FMX]
Access to: MogoDB databases
Based on components: FireDAC components by Embarcadero (TFDMongoQuery), avaliable since RAD Studio 10 Seattle.
Supported types of data queries: JSON
TRVReportIBDataProvider [VCL]
Access to: InterBase and Firebird databases
Based on components: InterBase Express components by Borland/CodeGear/Embarcadero (TIBQuery and TIBTable)
Supported types of data queries: SQL or table name
Data Providers Based on Lazarus Components
TRVReportDbfDataProvider [LCL]
Access to: DBF tables
Based on components: TDbf FCL components
Supported types of data queries: table name with optional filter
TRVReportSQLDataProvider [LCL]
Access to: multiple databases, including including Firebird, Microsoft SQL Server, Sybase ASE, MySQL.
Based on components: TSQLQuery FCL components
Supported types of data queries: SQL or table name
Data Providers Based on Third-Party Components
TRVReportAbsDataProvider [VCL]
Access to: Absolute database
Based on components: Absolute database components by ComponentAce (TABSQuery and TABSTable)
Supported types of data queries: SQL or table name
TRVReportDBISAMDataProvider [VCL]
Access to: DBISAM databases
Based on components: DBISAM components by Elevate Software, Inc. (TDBISAMQuery and TDBISAMTable)
Supported types of data queries: SQL or table name
TRVReportDxMemDataProvider [VCL]
Access to: any data stores available via TDataSet-based components; special support for TdxMemData by Developer Express Inc.
Supported types of data queries:
•names of TDataSet-based components
•for TdxMemData, the query may contain a filter describing the required values of fields (useful to implement master/detail reports)
TRVReportEDBDataProvider [VCL]
Access to: ElevateDB databases
Based on components: ElevateDB components by Elevate Software, Inc. (TEDBQuery and TEDBTable)
Supported types of data queries: SQL or table name
TRVReportIBCDataProvider [VCL]
Access to: InterBase and Firebird databases
Based on components: IBDAC components by Devart (TIBCQuery and TIBCTable)
Supported types of data queries: SQL or table name
TRVReportIBODataProvider [VCL, FMX, LCL]
Access to: InterBase and Firebird databases
Based on components: IB Objects components by Jason Wharton (TIBOQuery and TIBOTable)
Supported types of data queries: SQL or table name
TRVReportMyDataProvider [VCL]
Access to: MySQL databases
Based on components: MyDAC components by Devart (TMyQuery and TMyTable)
Supported types of data queries: SQL or table name
TRVReportMySQLDataProvider [VCL]
Access to: MySQL databases
Based on components: DAC for MySQL components by MicroOLAP Technologies LTD (TMySQLQuery and TMySQLTable)
Supported types of data queries: SQL or table name
TRVReportNxDataProvider [VCL]
Access to: NexusDB databases
Based on components: NexusDB components by NexusQA Pty Ltd. (TNxQuery and TNxTable)
Supported types of data queries: SQL or table name
TRVReportPgDataProvider [VCL]
Access to: PostgreSQL databases
Based on components: PgDAC components by Devart (TPgQuery and TPgTable)
Supported types of data queries: SQL or table name
TRVReportPSQLDataProvider [VCL]
Access to: PostgreSQL databases
Based on components: PostgresDAC components by MicroOLAP Technologies LTD (TPSQLQuery and TPSQLTable)
Supported types of data queries: SQL or table name
TRVReportUniDataProvider [VCL]
Access to: multiple databases via UniDAC, including Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, DB2, Microsoft Access, Sybase Advantage Database Server, Sybase Adaptive Server Enterprise, and other databases (using ODBC provider).
Based on components: UniDAC components by Devart (TUniQuery and TUniTable)
Supported types of data queries: SQL or table name
TRVReportZEOSDSDataProvider [VCL]
Access to: multiple databases via ZeosLib, including MySQL, PostgreSQL, Interbase, Firebird, MS SQL, Sybase, Oracle and SQLite.
Based on components: ZeosLib components (Download, Forum)
Supported types of data queries: SQL or table name