Need a response ASAP 1

[Guest_imported]

I need to know how to display the first occurence of a field, but suppress the whole lineif there is a duplicate field

 

[dgillz]

Right click on the details section of the report in the design window, and select format. To the right of the suppress checkbox is a button labeled X-2. This is for conditional suppression. CLick that button and ther the formula:

Not NoFirstRecord
{Fieldname} = Previous(Fieldname}) Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[Newbie69]

This NoFirstRecord is not working. It is giving me an error saying that I need a currenct,boolean or something right before the NoRecordFound.

 

[goranm]

Hi !

It is OnFirstRecord (not NoFirstRecord)

/Goran

 

[demunchkin]

I tried this statement in Crystal 6.0:

Not OnFirstRecord
{Fieldname} = Previous(Fieldname}

The errors I received were 'The remaining text does not seem to be part of the formula' if I pasted as is and changed the field names. If I added parenthesis I received 'Too many arguments' or the original error message. Is there something I'm missing?

 

[Naith]

Does OnFirstRecord change colour when you write it?

I'm not the authority on this, but I don't think OnFirstRecord was a valid function on v6.

How about

If RecordNumber > 1
Then {FieldName} = Previous({FieldName})

(I'm guessing at RecordNumber being valid in v6...)

Naith

 

[chelseatech]

The earlier formula will work if you write it as...
Not OnFirstRecord OR
{Fieldname} = Previous(Fieldname}

I added an "OR" between the two logical clauses. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm