Grand total in report

  • Thread starter Thread starter CL
  • Start date Start date
C

CL

Hi,

I have a report with a subreport. What I want to do is
have a grand total at the end of the report. In the main
report I have a text box that has this expression: =[sum
of billable hrs]*[rate] which is in the report footer
section and calculates the total amount for the main
report. In the subreport, which is also in the report
footer section of the main report, I have a text box that
has this expression: =Sum([Amount]) which is the total
for parts sold.

I've tried different expressions in the text box, that I
placed in the report footer, for the grand total but all
of which result in being asked for a value when running
the report.

Any help is greatly appreciated.

Thanks,

CL
 
Val,
I tried both suggestions you list below and now am being
asked for a value for Me in a pop-up window. Have any
additional suggestions? If more information is needed I
can provide it, I'm not sure what else is needed however.

Thanks in advance.

CL
-----Original Message-----
CL,
On the main report footer, below your subreport, you are
going to want to create a text box with an expression
something like this...

Me.text1 + Me.childreport.text2
or
Me.text1.value + Me.childreport.text2.value


This will take the two totals and add them together.
Where I have text1 or text2, that's the Name of the object
which you see on the properties menu.

Val
-----Original Message-----
Hi,

I have a report with a subreport. What I want to do is
have a grand total at the end of the report. In the main
report I have a text box that has this expression: = [sum
of billable hrs]*[rate] which is in the report footer
section and calculates the total amount for the main
report. In the subreport, which is also in the report
footer section of the main report, I have a text box that
has this expression: =Sum([Amount]) which is the total
for parts sold.

I've tried different expressions in the text box, that I
placed in the report footer, for the grand total but all
of which result in being asked for a value when running
the report.

Any help is greatly appreciated.

Thanks,

CL
.
Click to expand...
.
Click to expand...
 
Back
Top