Totals

Hello,

I have created a report with a sub report. I would like to add a Total field
in my main Report Footer that calculates the sum of a field in my Sub
Report.

I thought I could get away with:

=Sum(subreport.Report!field)

but it's not working.

What am I doing wrong?

Thanks,

Helen

Try doing the calculation in the Sub report footer then set the text box in
the report footer to that field name. You can always hide it in the sub
report if you don;t want to see it there. I don't know why it does not work
the other way. HTH

Sheila

"Helen" wrote:

Hello,

I have created a report with a sub report. I would like to add a Total field
in my main Report Footer that calculates the sum of a field in my Sub
Report.

I thought I could get away with:

=Sum(subreport.Report!field)

but it's not working.

What am I doing wrong?

Thanks,

Helen

Hi there,

I must be doing something wrong.

I created a sum field in the report footer of my subreport. It's called
Text17.

Then I created another sum field in the main report footer like this:
=(Sum(srpt_MasterBillOfLading.Report!Text17)) but when I run the report it
asks me for the Parameter Value.

Any suggestions what I'm doing wrong?

Thanks!

Helen


"Sheila D" wrote in message
...
Try doing the calculation in the Sub report footer then set the text box
in
the report footer to that field name. You can always hide it in the sub
report if you don;t want to see it there. I don't know why it does not
work
the other way. HTH

Sheila

"Helen" wrote:

Hello,

I have created a report with a sub report. I would like to add a Total
field
in my main Report Footer that calculates the sum of a field in my Sub
Report.

I thought I could get away with:

=Sum(subreport.Report!field)

but it's not working.

What am I doing wrong?

Thanks,

Helen