Account Income and Forecast Report; Report is slow to generate

The Account Income and Forecast Report is one of the slowest Reports to create because of the work it has to do.

However, after the Query is complete it can take a long time to produce the actual Report. You may see "Cleaning query results" in the progress window at this stage.

The following changes have been made:

1. The Progress window now displays "Query complete" once the Query results have been cleaned.

2. 99 columns are always created and processed. This is now optimised, where possible, based upon the number of columns selected for the Report.

3. The sub-query for Elements was incorrectly creating 294 value columns - rather than the number of columns selected for the Report.

Note, the more rows/ records and the more columns included in any Report the more processing is required and the more memory used, and this can lead to performance issues.