Add the Total from two Subreports

I have a report that in one section has two seperate subreports that have their own total.
eg
Job #        Sub1:total labour       Sub2:total parts

I am trying to get (total labour + total parts) to show at the end of this section.

Is this possible?
robd2007Asked:
Who is Participating?
 
SpykairCommented:
You'll have to declare the shared variable before the sub report. Then you can use it in the main report.

Spykair
0
 
SpykairCommented:
Yes.
You can create a formula column where you add these 2 fields together.

Spykair
0
 
robd2007Author Commented:
When I go to create a new formula in the main report, the field names are not listed to be used.

Do i have to do anything to make it so i can see then in the formula editor?
0
 
robd2007Author Commented:
When i say field names from the subreports, i should have described as the result from a shared variable i set up in the subreports, to try to get it out in the main report.
0
 
SpykairCommented:
Glad I could help

Spykair
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.