Suppressing few columns in a record based on the uniqueness of another

[kala1234]

Hi,

I have a requirement for suppressing all the columns except 2 based on a condition. Condition is as follows:
If the value of the first column is the same i need to suppress all the fields except 2...Can i do like this in Crystal..If yes...please tell me how i can achieve this..


Thanks in Advance
Sreekala

 

[synapsevampire]

Your description leaves too much to the imagination, post sample data and desired output.

"value of the first column is the same"

The same as what? A duplicate, another column?

The means for suppression of anything which is a duplicate would be something like:

In the suppression formula for the fields to suppress, place something like:

{table.Field} = previous({table.field})

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[kala1234]

Hi now my data is comming in this format

Column 1 | Column 2 | Column3 | Column 4 | Column 5
------------------------------------------------------
a1 | a2 | a3 | a4 | a5
a1 | b2 | b3 | a4 | a5
a1 | c2 | c3 | a4 | a5

m1 | m2 | m3 | m4 | m5
m1 | n2 | n3 | m4 | m5
m1 | l2 | l3 | m4 | m5

I want this to appear as
Column 1 | Column 2 | Column3 | Column 4 | Column 5
------------------------------------------------------
a1 | a2 | a3 | a4 | a5
| b2 | b3 | |
| c2 | c3 | |

m1 | m2 | m3 | m4 | m5
| n2 | n3 | |
| l2 | l3 | |

Any clue,

Thanks,
Kala.

 

[synapsevampire]

For the suppression formula (right click the field, select format field->Common->X-2 next to suppression) for columns 1,4,5 use:

{table.column1} = previous({table.column1})

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[lyanch]

You can also just select "supress if duplicated"

Lisa

 

[synapsevampire]

Suppress when duplicated won't work because the duplication is based on column 1, not the other columns, unless the duplication will always exist for all of the suppressed columns.

The requirement said it's based only on Column 1.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[kala1234]

The formula worked very well for me.. Thanks a lot.
But i have noticed one more thing, when the field values get supprressed in the preview the first row will be shown with all values and the other rows are getting pushed down (i mean leaves blank space in between the first row and the other rows which got suppressed).But in export it is comming fine.There is no new line between the rows.

Any idea, whether it is a drawback of the crystal itself...???