Hi guys, I'm having difficulty to generating a query screen that has sub-total breaks and a general total at the end (see attachment).I made an aggregate that produces the lines, but I can not put the subtotals. Can anybody help me?
Hi Fernando,
Just clear your requirements more clearly, so I can help you in this.
Regards
Rajat Agrawal
Acc to sceenshot, we imagine you have 10 records after 5 records you want subtotal break. At the end total break?
I just want to know on which condition you are showing sub total.
Rajat Agrawal wrote:
Hello Hajad,Thank you for your help.There was a post from Daniel below where I will test if it resolves.Thank a lot
You have two options:
- using a new query and place the total under the table records, or you can add a new line and append the subtotal line in the end.
- Change the original query to an advance query and write your own SQL query to get the output desired, you would need to something like this https://stackoverflow.com/questions/19387650/how-to-add-a-subtotal-row-in-sql
Hope it helps you
Daniel Martins wrote:
Hello'daniel,Thank you for your help.I think the example with the function RollUp () should solve. I will run the tests and inform you if it was successful.
Thanks a lot