Total sum from subreports

[Sanasta]

I have a report with 5 subreports. Each subreport has in its footer sum of spesific expenses. In main report I
have summed these sums. In case any subrepost is missing, my final sum is error. I have tried with NZ, IsError, Is Null, IsEmpty functions, but result is the same.
Kindly please help me
Sanasta

 

[synapsevampire]

The problem is likely that one of these values is null, so the grand total sum fails.

Place a formula like this in a section prior to running the subreports

whileprintingrecords;
shared numbervar sub1sum:=0;
shared numbervar sub2sum:=0;
shared numbervar sub3sum:=0;
shared numbervar sub4sum:=0;
shared numbervar sub5sum:=0;

And in the subreports you might use a null check to assure that it returns 0:

whileprintingrecords;
shared numbervar sub1sum;
If isnull(sum({table.value})) then
0
else
sum({table.value})

-k

 

[Sanasta]

I shal try
Many Thanks

 

[jblewis]

This is a little off topic, but what you said you alread y have (the summation of subreports) is exactly what one of my co-workers just asked me about. If you could give me some info on how that is done, that would be fantastic!

Thanks!

JBLewis