Adding Totals on a Report? 1

[Jetter88]

hi..

I have a master/detail report.
The report works fine... it prints the header and the line items nicely. Now, I need the totals of the line items to add up for me and be displayed in a 'Total' field. So there can be unlimited number of line item, but 1 'Total' field number.

How do I do this? Is there a way in the SQL statement within the report or does Reports Developer have some sort of feature.

Thanks in advance!

 

[nagornyi]

You need to create summary column in the Data Model, that woul summarize detail fieled with reset on Report. Look uo summary column, creating in the Report Builder help index for more info.

 

[Jetter88]

Thank you. I used that to total up the line items at the end of the row. That was perfect.

Now... how can I total up the line items total into one total for the bottom of the report?

example: desc/qty/price/total
line1 /2/3.00/6.00
line2 /3/1.50/4.50
line3 /6/2.00/12.00

report total: ? (should be 22.50)

thanks in advance!

 

[nagornyi]

Same thing. Create total column outside any group, and reset it at Report.

 

[Jetter88]

Thanks... this is what I did...

Created a Formula Column on the report level and summed the totals of the SubTotal and TaxTotal, which were on the report level too.

function CF_1Formula return Number is
temp number;
begin
temp := :SumSUBTOTALPerReport + :SumTAXTOTALPerReport;
return (temp);
end;