Report with Sub-totals

Report with Sub-totals

  


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.

Regards

Rajat Agrawal


Hi Fernando,


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:

Hi Fernando,


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

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

Rajat Agrawal wrote:

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.

Regards

Rajat Agrawal


Hello Hajad,
Thank you for your help.
There was a post from Daniel below where I will test if it resolves.

Thank a lot