Hi All, i am try to create a "TRUE/FALSE" formula to display a logo based on "Franchise" in ONLY the first row of data. there could be multiple rows of data and franchises as shown below.

Description    Row Number   Franchise      Qty
Filter                   1              68            1
oil                      2              13            5
plugs                   3              98            6

i used this formula until recently....

booleanVar S;
if PreviousIsNull ({tblDocRigDocumenti001.rownum}) then if
{tblDocRigDocumenti001.Franchise} = 68 then
S:=True
else
        S
Else
   S

this formula only looked at "Row 1" then checked the franchise, and returned True or false.

"WE" have recently added another row of data which is now "Row-1" so the "PreviousIsNul" no longer is valid and has screwed up this formula.

any help would be greatly appreciated.

Regards Wayne

Hi DBlank and thanks for the quick response.

i did not write the original formula but as i understand it, the way it was written was to "force" crystal to only look at the FIRST line, then read the franchise.

i have substituted "recordnumber" and the result is still false (in the case below should be true)
EG: booleanVar S;
if recordnumber = 2 and
{tblDocRigDocumenti001.franchise} = 68 then
S:=True
else S;

i have also tried both of your suggestions above and both return a "blank" field??
EG: the field is set to "boolean Text: true or false" but when run results in neither a true or false result??

i think i see were the confusion is...
the logo is in the page header which is were the formula needs to be.

if it is at line level it works fine, (for line 1 and "68") however at page header level it is reading ALL lines which is (i think) why i keep getting the "FALSE" result.

DBlank you are a genius.. whilst i havent used the above exactly you have made me think "outside" the box.
the form can have several franchises or only 1, so what i have done is this.

on each line i have assigned a value based on the actual franchise EG:
if {tblDocRigDocumenti001.rownum}=1 and {tblDocRigDocumenti001.franchise} = 6 then 6 else
if {tblDocRigDocumenti001.rownum}=1 and {tblDocRigDocumenti001.franchise} = 15 then 15 else
if {tblDocRigDocumenti001.rownum}=1 and {tblDocRigDocumenti001.franchise} = 52 then 52 else 0

then in the Page Header i have this EG:
Sum ({@Franchise})
which will return a value ONLY from line 1 based on the formula above.

i then suppress each logo that does not equal that value...

Not what i would class as pretty but its working.

Many Thanks for you assistance DBlank.