Total Problem

[Jen]

I have a main report for Order details (RepOrders), and within it a subreport
(RepInvoices). The subreport has details and a total of all invoices in its
footer called INVs.

I have successfully put a text box in the main report called InvTotal with
the following expression:

-IIF (RepInvoices.Report.HasData,RepInvoices.Report.Invs,0)

And this also shows the invoice total from the subreport in the main report.
Great so far!

I then have successfully put another text box into the main report called
Order-Invoice, with:

=[Amount]-[InvTotal]

which shows the Order total minus the total of all the invoices.

Going well so far. However...

I want to put in another text box in the the Group footer of the main report
which adds up all the 'InvTotal', ie shows grand total of all the Invoices.
But I can't find a way to do this.

I have tried various expressions and nothing works. It's seems like such a
simple thing but I just can't find the answer. If I could just get this
working my report would be complete!

Thank you for any help - it's much appreciated.

 

[Marshall Barton]

I have a main report for Order details (RepOrders), and within it a subreport
(RepInvoices). The subreport has details and a total of all invoices in its
footer called INVs.

I have successfully put a text box in the main report called InvTotal with
the following expression:

-IIF (RepInvoices.Report.HasData,RepInvoices.Report.Invs,0)

And this also shows the invoice total from the subreport in the main report.
Great so far!

I then have successfully put another text box into the main report called
Order-Invoice, with:

=[Amount]-[InvTotal]

which shows the Order total minus the total of all the invoices.

Going well so far. However...

I want to put in another text box in the the Group footer of the main report
which adds up all the 'InvTotal', ie shows grand total of all the Invoices.
But I can't find a way to do this.

I have tried various expressions and nothing works. It's seems like such a
simple thing but I just can't find the answer. If I could just get this
working my report would be complete!

Add a text box (named txtInvRunTotal) to the main report
detail. Set its expression to =InvTotal and set its
RunningSum property to Over Group. Then the group footer
text box expression would simply be =txtInvRunTotal

 

[Jen]

Thanks Marshall

I tried this and what it gave me was a running sum of invoices. This isn't
really what I need.

The main report is grouped into Area and then Order, and I have managed to
get the Invoice Total to show on the subreport, and also on the main report
in the Order footer. I now need to show the total of all invoices within the
Area, either in the header or footer.

I hope this makes sense, and thank you for your help so far!

 

[Marshall Barton]

I tried this and what it gave me was a running sum of invoices. This isn't
really what I need.

The main report is grouped into Area and then Order, and I have managed to
get the Invoice Total to show on the subreport, and also on the main report
in the Order footer. I now need to show the total of all invoices within the
Area, either in the header or footer.

The text box in the order footer should show the total for
invoices in the order. If you don't want to see the running
sum in the detail section, just make the running sum text
box invisible.

To get a total for the area, use the same mechanism in
another running sum text box in the order footer. The area
footer could then display the area total in a text box that
refers to the order running sum text box.