Suppressing Duplicates

[mmemon]

Hello Everyone,

I created a Text Object and dragged 3 formulas into the text object. I clicked on Suppress if duplicated but it is not working. ie:

John Doe(1001) Inactive as of: 12-01-2002
John Doe(1001) Inactive as of: 12-01-2002

The second record doesn't get suppressed. I am looking to evaulate a row and suppress if the row is duplicated. That is why I dragged the formulas into a Text Object.

How can I accomplish this? Thanks!

 

[synapsevampire]

Interesting, I don't place formulas into text objects often, sounds like a buglet.

An alternative might be to use the next() function:

If next({field1})+next({field2})+next({field3}) =
{field1}+{field2}+{field3} then
""
else
{field1}+{field2}+{field3}

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[mmemon]

K,

Thanks. Do you know of something other than the Space function I could use to separate field1 and field2. I would like to start the second field at a specific place so it would line up like a column. ie: (this is how it shows with the Space function)

John Doe Inactive
Stephanie Dung Inactive

 

[JacobsAunt]

I suggest placing the 3 formulas individually. You can then use the section expert to create a formula that will suppress rows based on your criteria (I suggest an AND Formula)

{Formula 1} = {Formula 1}
and {Formula 2} = {Formula 2}
and {Formula 3} = {Formula 3}

This way, you can suppress rows that are duplicates, and still line up the formulas

KT