FIX4.00.03 · Released 27 September 2023
FIXfinPOWER Connect
Released in
4.00.03
27 September 2023
  1. Opened25 Jul
  2. Closed26 Jul
  3. Released27 Sep
Article 20504 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