How to show dummy text if duplicated field 1

[JanTore]

How can i show some dummy text when i have a field suppressed if duplicated.

If {field} = previous({field}) Then
"Same as above"
Else
{field}

 

[dgillz]

Place this formula field right on top of your existing field. Conditionally suppress it with a Formula:

Not OnFirstRecord;
If Previous({field})={field} then true

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[JanTore]

Now i got confused
Do you mean like this, on top?

Not OnFirstRecord;
If Previous({field})={field} then true 
If {field} = previous({field}) Then
   "Same as above"
Else
   {field}

I get a error message from that.
And if i just use the formula that you suggested it does the same as using the 'Suppress if duplicated' in the format object -> common menu.

And then i wont get the text showing "Same as above" if its duplicated

 

[lbass]

It looks like you DON'T want the field suppressed if duplicated, but that you want to show a statememt that it is duplicated, so remove your suppression and instead replace the field with a modification of your formula in your first post:

if not onfirstrecord and
field} = previous({field}) Then
"Same as above" Else
{field}

-LB

 

[dgillz]

Yes LB captured and put in writing what I had in my head. Words are important.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[JanTore]

That was what i was looking for, thanks both of you.