Hi,

In SQL Report Data I created a query in which I want to define sub totals.

Example:

Supplier Receipt Amount in HC

100 150
2005
____
Subtotal: 2155

200 123
254
____
Subtotal: 377
____
Total: 2532

What is the way of setting subtotals and totals, while keeping the details/lines.

Thanks,

Erik

You will have to use "after.field" and "after.report" layouts to achieve this. Set the field you want to group about as sorted in the input fields of the report.

Then you can define an "after.field" layout for this field in the "maintain layouts" session. In that layout, place the field over which you want to sum the values and put the "aggregate" Flag to "Total".

Do the same in an "after.report" layout to get the sum over all groups.

Hope that helps a bit
Uli

Vielen Dank, Ulrich! Es hat funktioniert.

Erik