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