I'm baffled. Crystal Reports 11. Simple report with no subreports. Layout as follows.
RH
PH
GH1
D
GF1
RF
PF
I have several formula fields across. Each field has the same formula (as follows) except I check for a different "type" and the "resultvar" is named differently for each.
NumberVar ResultVal3;
If {test.TYPE}='X' and {test1.TRANSTYPE}<>'Y' Then
ResultVal3:={test1.DOLAMT}
Else
ResultVal3:=0;
ResultVal3
I have a sum for each field in GF1 and a grand total sum in RF.
Problem is on one field only, the grand total shows 0.00 even though there are amounts that show in the details section. The field in question also shows the correct amounts in the GF2 sums; just nothing in the grand total. I have checked the syntax to death (not that there is much to check when inserting a grand total). I've deleted and remade the grandtotal field several times.
Thanks for any help,
RH
PH
GH1
D
GF1
RF
PF
I have several formula fields across. Each field has the same formula (as follows) except I check for a different "type" and the "resultvar" is named differently for each.
NumberVar ResultVal3;
If {test.TYPE}='X' and {test1.TRANSTYPE}<>'Y' Then
ResultVal3:={test1.DOLAMT}
Else
ResultVal3:=0;
ResultVal3
I have a sum for each field in GF1 and a grand total sum in RF.
Problem is on one field only, the grand total shows 0.00 even though there are amounts that show in the details section. The field in question also shows the correct amounts in the GF2 sums; just nothing in the grand total. I have checked the syntax to death (not that there is much to check when inserting a grand total). I've deleted and remade the grandtotal field several times.
Thanks for any help,