Does anyone know why a running sub-total changes if I hide the details section? If I show the details, the total is correct but if I supress or hide, it changes.
I have found that if I have "Select Distinct Records" selected, and fields within the Details section make a record distinct, that hiding that section may change the total number of records retrieved from the query.
You may want to either unselect the option for distinct records, or add criteria/fields to the report so that all the records you want to see are included in the report.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.