Incrementing in the formula using string 1

[crystaldev1]

Hello. I'm using CR 9 and Sql Server 2005.

I have this formula:

if (instr(TotalItem,Item) > 0) then ""
else TotalItem := TotalItem + Item;

I would like to add increment formula to the else condition as below:

if (instr(TotalItem,Item) > 0) then ""
else TotalItem := TotalItem + Item and X:=X+1;

Please let me know if there's a workaround for this. Thanks.

 

[IanWaterman]

Just repeat in same formula, however you can not mix strings and numbers in an if..then..else

@EvalVars
whileprintingrecords;
global stringvar TotalItem;
global numbervar X;

if (instr(TotalItem,{Item}) < 0) then
TotalItem := TotalItem + {Item};

if (instr(TotalItem,Item) < 0) then X:=X+1;


Ian

 

[lbass]

It could be done like this:

whileprintingrecords;
global stringvar TotalItem;
global numbervar X;

if (instr(TotalItem,{Item}) < 0) then (
TotalItem := TotalItem + {Item};
X:=X+1
);

-LB

 

[crystaldev1]

Thanks!