Adding Two subreports together

  • Thread starter Thread starter David Tunstall
  • Start date Start date
D

David Tunstall

Please help,

I have tried every expression I know to add together two
subreports on a report and the closest I can get is where
it puts the two values together and doesn't actually add
them:

A1.Count = 2
A2.Count = 8

The following expression gives me 28 instead of 10

=[A1].[Report]![Count]+[A2].[Report]![Count]

Please help
Thanks
David
 
I also am in the midst of creating a program which does use quite a few
sub-reports with even sub-reports of their own.
In one instance I have 2 sub's named B5a1 and B5a2 both having a sum field
of their own as "bas_ch_rel" and "sayi" respectively.

On the main report I have used an unbound textbox with the following control
setting:
=B5a1.Report!bas_ch_rel+B5a2.Report!sayi
that does give me the correct sum of the two. It might have something to do
with the "[" and "]" in your expression, I do not have them in mine.

Alp
 
I'll try that, thanks
-----Original Message-----
I also am in the midst of creating a program which does use quite a few
sub-reports with even sub-reports of their own.
In one instance I have 2 sub's named B5a1 and B5a2 both having a sum field
of their own as "bas_ch_rel" and "sayi" respectively.

On the main report I have used an unbound textbox with the following control
setting:
=B5a1.Report!bas_ch_rel+B5a2.Report!sayi
that does give me the correct sum of the two. It might have something to do
with the "[" and "]" in your expression, I do not have them in mine.

Alp

Please help,

I have tried every expression I know to add together two
subreports on a report and the closest I can get is where
it puts the two values together and doesn't actually add
them:

A1.Count = 2
A2.Count = 8

The following expression gives me 28 instead of 10

=[A1].[Report]![Count]+[A2].[Report]![Count]

Please help
Thanks
David
Click to expand...


.
Click to expand...
 
Try explicitly converting the references to numeric values.
=Val([A1].[Report]![Count])+Val([A2].[Report]![Count] )
 
Back
Top