zobernjik
August 23rd, 2004, 08:23 PM
I have a report that has a subreport,main report has one column with values,subreport can have up to two columns and displays values as well.
Value from the main report gets added onto each column from the subreport to create a total per column(which are like estimates).
Problem that I have is the value from the main report gets added and placed where the value for the second column should be, even if I don't have the second column,which is what I don't want.
This is the formula for column A,it is the same for column B.
WhilePrintingRecords;
Shared NumberVar dTotalA;
dTotalA + SUM({Budget.ExpAmount})
How can I change this formula so it doesn't display the total from the main report when the second column from the subreport doesn't exist.
Thanks
Value from the main report gets added onto each column from the subreport to create a total per column(which are like estimates).
Problem that I have is the value from the main report gets added and placed where the value for the second column should be, even if I don't have the second column,which is what I don't want.
This is the formula for column A,it is the same for column B.
WhilePrintingRecords;
Shared NumberVar dTotalA;
dTotalA + SUM({Budget.ExpAmount})
How can I change this formula so it doesn't display the total from the main report when the second column from the subreport doesn't exist.
Thanks