I have subtotals on my report and they don't add up to reflect the correct number. Why is this?
There are a number of possible reasons why this could be the case.
The Preview Results dropdown indicates how many records should be shown in the preview. This is just a sample of all the data in the report. If a report has 10,000 records, we don't always want to display all of those records in one page in the browser. The default number of Preview records to display is 100. Even if there are more than 100 records, by default the first 100 will be displayed. However, the aggregated subtotal will sum up all records, whether they are displayed or not in the viewer.
If TOP (limit to N records) is used (and it is used in most cases), then subtotals results can be wrong if there is no ORDER BY (sorting) applied to at least one field.
Last edited by ericpfeifer-izenda, 2018-08-29 15:31:26