Previous Topic
User Defined Data Sources
Logi JReport Designer can access data from an external data source, such as a text file, or Excel file, which is not stored in a database, or when there is no JDBC driver available. This feature uses the user data source API provided by Logi JReport. In addition, due to the unique nature of Oracle and Enterprise DB stored procedures, you will not be able to add them into a Logi JReport catalog directly. As a substitute, Logi JReport has developed a user data source class that can use stored procedures in Oracle and EnterpriseDB.
Queries and business views can be built on user defined data sources and a report is developed from a query (or something else which is functionally similar) or from a business view.
A user defined data source itself can be used to create page reports directly, and in this sense it functions the same as a query. Therefore you can use the Data Manager to control the data retrieval of user defined data sources, including the number of rows to be displayed and the duration allowed for the retrieval, and use the manager to keep access information from previous runs of a UDS. You can also create cached result files for user defined data sources and save the result files somewhere in your machine, then when you view reports based on the UDSs, you can choose to use the data from the cached query result files as opposed to the database.
The following topics describe tasks associated with User Defined Data Sources: