Skip to content
Ask A Question
  • There are no suggestions because the search field is empty.

Dynamically Generate Report Inputs from a Database

Is it possible to configure Dream Report to dynamically build some of my report input parameters? For example, I want to be able to generate a my tag list on demand from a database. How do I do this?

The Dream Report Settings contains a Report Preprocessor that allows you to issue a database command, such as a SQL query or a stored procedure, which can be performed before a report is generated. It can then use the result of that query as an input for your report.

The query will allow you to dynamically define: a list of tags, the units for the tags, a minimum value and a maximum value.

Input parameters can be replaced for the following objects: Charts, Automatic Statistical Tables, and Item Tables.

For more information on this feature review the Report Preprocessor section of the Dream Report User Manual (p. 199) installed with the software or available online here.