How to Suppress Multiple columns value ?

[CrystalReports9]

Existing data in the detail portion of the report is like the following:

c1 c2 c3 c4 c5
--- ---- ------ ---- ----
10 Clerk GradeA Anto 1000
10 Clerk GradeA Maxe 2000
20 Sales GradeB Tame 5000
20 Sales GradeB Rane 8500
20 Sales GradeB Gane 5500
30 Clerk GradeA Umas 8500
30 Clerk GradeA Vini 8500

OUTPUT
------
c1 c2 c3 c4 c5
--- ---- ------ ---- ----
10 Clerk GradeA Anto 1000
Maxe 2000
20 Sales GradeB Tame 5000
Rane 8500
Gane 5500
30 Clerk GradeA Umas 8500
Vini 8500

How to achieve this? Pls help me. Thank u.

Rgs
Anto

 

[pgtek]

hi

create a group base on your display resutl
like

group 1 could be c1

 

[bdreed35]

1. Right click the c1 field in your detail section
2. Choose Format Field
3. Select Common tab if it is not already selected
4. Select the "Suppress if Duplicated" check box
5. Click Ok and Preview yor Report



~Brian

 

[CrystalReports9]

Hi Guys...

Thanks for the reply...But i failed to achieve it.

But i want to display the result in the detail level. Not with by creating the Group. If i create the Group then the format of the report is changed.

Also the option 'Suppress If Duplicated' for the single column. i want to do it for the column c1, c2, c3 together.

Pls help me. Thank u...

 

[bdreed35]

Did it work for the c1 column? If it did, just repeat the same steps for the other detail fields.

~Brian

 

[CrystalReports9]

Hi Brian

I use the group option on c1, c2, c3. But it will change the report layout like
10
Clerk
GradeA
Anto 1000
Maxe 2000

I want to display like a row. Not like hierarical formalt.
10 Clerk GradeA Anto 1000
Maxe 2000

Without using group, can i write the formula in the option 'Suppress If duplicated'??? Give me hints...

Thank u

 

[bdreed35]

Try this with your current report structure:

1. Right Click to the left of your report canvas where it says Group 1 Header.
2. Choose Section Expert.
3. For each Group Header, choose the option "Underlay Following Sections"
4. Click OK and Preview the Report

~Brian

 

[CrystalReports9]

Hi Brian....

So Sweet of you....Its now become Woww....Thank U...

Luv
Anto