SubReport/Report Totals

[sparklegrrl]

I have searched all over the forum and can't find help on this one.

I have a sub report (InvoiceTimeSub) that has 3 exp fields.

The 1st one multiplies the reg hrs worked * reg pay rate, the 2nd one (exp2) multiplies the ot hrs worked * ot payrate and the 3rd one (exp3) multiples exp2*exp3.

On the bottom of the subreport I have a textbox that has
=sum([exp3]).

All is working just fine.

I can't figure out how to carry the total of exp3 to the main report (Invoice).

 

[sparklegrrl]

OOPs...I wrote the 3rd exp on the subform wrong. It is
=Sum([exp1]+exp2]). Sorry about that.

 

[D.Mair]

you need to do the calculation again in the main report well thats what i do!!


In main report

textbox1=Sum ([InvoiceTimeSub].[Report]![exp1])
textbox2=Sum ([InvoiceTimeSub].[Report]![exp2])
textbox3= ([textbox1]+[textbox1])

is this what you are after. if not reply and i will try to help


David

 

[Rich]

Search here for examples of the HasData method

 

[sparklegrrl]

you need to do the calculation again in the main report well thats what i do!!


In main report

textbox1=Sum ([InvoiceTimeSub].[Report]![exp1])
textbox2=Sum ([InvoiceTimeSub].[Report]![exp2])
textbox3= ([textbox1]+[textbox1])

is this what you are after. if not reply and i will try to help


David

That didn't work...it came up #Name? when I ran the report