Crystal Report Field Supression

steven
steven used Ask the Experts™
on
We are trying to hide a field in crystal report 2013 based on a formula.  We have added a formula called testcount as
local numberVar count:= 0;
local stringVar comma := {Ens_RptSingleCertNew;1.job};
Local numberVar strLen:=length(comma);
local numberVar I;
for i:=1 to strLen do

    If Mid(comma,i,1)= ","
        then count := count +1;
count;

We attempt to suppress the field based on the count being > 2 .   This has no effect yet when we display the count on the report it show as 3.00.  We only need to hide this one field any help would be appreciated.    We have the field suppression set as:
{@TESTCOUNT} > 2.00
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
developer
Commented:
I added the WhilePrintingRecords/EvaulateAfterto suppression and it worked. see below

WhilePrintingRecords;
EvaluateAfter({@TESTCOUNT});


IF ({@TESTCOUNT}) > 2.00 then
TRUE
Else
false
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
I suspect you don't need the WhilePrintingRecords, just the EvalauteAfter

mlmcc

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial