Subtotal of nested loop over levels does not match

jeanful — Fri, 22 Aug 2025 09:21:31 GMT

Hello, I built a pixel perfect template in QS Cloud. I have the following configuration:

- Created a level called "Table Export"

- Created the "DetailReport1" section: here I configured the data member as "Table Export" level

- Under the "DetailReport1" I have a group header section, a detail section, a group footer section

- In header I put some titles, the month (the need is iterating over the month, i.e. one month -> one page) and a subtotal of the month. To do so, I configured Group Union: with first detail; Group By: Month

- In detail I put the labels coming from the level, so I built a table with all the rows of the level

- In footer I put the subtotal. I configured Group Union: with first detail, No Group By option here.

While the month in header is correct, the subtotals (both in header and in footer) are wrong. They show the total amount of all the months, instead of the one of the month of the page.

Thank you for supporting!

Re: Subtotal of nested loop over levels does not match

jeanful — Fri, 22 Aug 2025 09:26:18 GMT

Just found the function SumSum! That's what I needed

topic Subtotal of nested loop over levels does not match in Reporting Service & Alerting

Subtotal of nested loop over levels does not match

Re: Subtotal of nested loop over levels does not match