Have a repot with a subreport, this code below is the forumula code within the subreport where I am trying to have the total from two columns displayed
WhilePrintingRecords;
Shared NumberVar dTotalA;
Shared NumberVar dTotalB;
if({rptRemovalistCrosstab.RemovalistNumber}=1) then
dTotalA:=dTotalA + {rptRemovalistCrosstab.Removals}
else
dTotalB:=dTotalB + {rptRemovalistCrosstab.Removals};
So that was before and that was great,if Removalist 1 was used create dTotalA else dTotalB, now we are looking at the selected Removalist which could be one or more, and that is a bit field.
So how can I create totals if I have more then one Selected=true
WhilePrintingRecords;
Shared NumberVar dTotalA;
Shared NumberVar dTotalB;
if({rptRemovalistCrosstab_01.Selected}=true) then
dTotalA:=dTotalA + {rptRemovalistCrosstab_01.Removals};
hope this makes sense and somebody can help me
thanks
WhilePrintingRecords;
Shared NumberVar dTotalA;
Shared NumberVar dTotalB;
if({rptRemovalistCrosstab.RemovalistNumber}=1) then
dTotalA:=dTotalA + {rptRemovalistCrosstab.Removals}
else
dTotalB:=dTotalB + {rptRemovalistCrosstab.Removals};
So that was before and that was great,if Removalist 1 was used create dTotalA else dTotalB, now we are looking at the selected Removalist which could be one or more, and that is a bit field.
So how can I create totals if I have more then one Selected=true
WhilePrintingRecords;
Shared NumberVar dTotalA;
Shared NumberVar dTotalB;
if({rptRemovalistCrosstab_01.Selected}=true) then
dTotalA:=dTotalA + {rptRemovalistCrosstab_01.Removals};
hope this makes sense and somebody can help me
thanks