Article Details
Id:20504
Product:finPOWER Connect
Type:FIX
Version:4.00.03
Opened:25/07/2023
Closed:26/07/2023
Released:27/09/2023
Job: J031647

"Report" and "Query" Report Templates not using a configured Reporting Database

Databases configured to use a Reporting database and Report / Query Type Report Templates were incorrectly running the Reports on the main database, not the Reporting database.

'Ad-Hoc Query' Report Templates give the option to either run on the Report database, but the other types were assumed to use whatever the Reporting database settings in Global Settings dictated. This was not being applied correctly, however, and the result was that they were always using the main database.

This has been fixed, and now "Report" and "Query" Report Templates will respect what is configured in Global Settings.

To support this, two new Properties have been added:

finReportTemplate.UseReportingDatabaseResolved
finReportTemplateRO.UseReportingDatabaseResolved

These properties apply the following logic:

  • If Report Type is "Query" or "Report"
    • Use the Reporting database Global Setting
  • For any other Report Type (Ad-Hoc Query)
    • Use the setting on the Report Template