Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Total from Sub-Report

Status
Not open for further replies.

pleashelp

Technical User
Feb 27, 2002
97
US
I have a report with a sub-report. In the sub-report I have a Sum of Total $Printed in Report Footer A. In Report Footer B I have this formula:

whileprintingrecords;
shared numbervar Printed := Sum ({@Total $Printed})

In the main report I put the sub-report in Report Footer B. Also in RF B I have a formula called Sum ( @Ticket Out).
IN RF F I put this formula:

whileprintingrecords;
shared numbervar Printed;

Printed+Sum({@TicketOut})

Unfortunately the result I get is the Sum (@TicketOut). It does not add in the var Printed.

What am I doing wrong?

Thanks.
 
Create a Report Footer C and put in the formula :

whileprintingrecords;
shared numbervar Printed;
Printed+Sum({@TicketOut})


Reebo
Scotland (Sunny with a Smile)
 
OK...same report...slightly different sub-report. In the sub-report in Detail B section, I have this formula

whileprintingrecords;
shared numbervar Liab := {@Liability}

Now if I allow this field to be visible, it brings up the correct total within the sub-report. Then in the main report I put the sub-report in Report Footer Section C. And in Report Footer Section D I put this formula

whileprintingrecords;
shared numbervar Liab;
Liab + Sum ({@TicketIn})

But this formula only displays the amount for
Sum ({@TicketIn}).... not the Liab + Sum ({@TicketIn})

If I move this formula down to the PAGE Footer, it shows the correct amount..but I don't want to put it in the page footer. How can I fix this?



 
What I finally ended up doing was, that I simply deleted both of the fields in question, and rewrote them from scratch the same way. For some reason that worked! So, problem solved!

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top