crSingleLine Suppress Formula help 2

[cyreports]

I am trying to get this formula to work and can not seem to make it do the top line right. No matter what Grouping equals, I am getting the line. I want it to suppress when Grouping equals 'None', yet its still printing.

IF {?SUPPRESSDETAIL} = FALSE AND {Data.Grouping} = 'None' then
    crNoLine
ELSE
    crSingleLine

 

[IanWaterman]

Does {Data.Grouping} have spaces and are you sure case is right

try

IF {?SUPPRESSDETAIL} = FALSE AND uppercase(trim({Data.Grouping})) = 'NONE' then
crNoLine
ELSE
crSingleLine

Ian

 

[GJParker]

Try putting both of the fields you are testing against on the report and check what values are being returned.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[cyreports]

Thanks Ian.

 

[cyreports]

I ended up removing the '{?SUPPRESSDETAIL} = FALSE AND' since I had that already on the group footer suppression and it worked. Thanks for looking and the input!