Query Builder
- Fix – Dynamic Columns based on Dates with a Year/Month function applied to them would not work correctly in Excel if dates were referenced in cells instead of text in YYYY/MM format.
- Fix – Dynamic Columns would fail to display correctly if the filter criteria resolved to zero combinations. For example, 2005/001 to 2004/001 notice the end period is less than the start period.
Reporting Rows
Fix – Sub Queries that were reference from Expressions would not total correctly and would show the last row value above. This would happen if the Expression referenced the sub output of the Sub Query instead of the root reference. E.g. {%S1234.Amount} instead of {%S1234}. If in doubt always reference the root Sub Query reference name.