suppress duplicate on non recurring field

[Jaedyn]

Hello all,

I am using Crystal 9 accessing a Unix database with a procrdure powering the report.

My problem is simple but is eluding me. I need to suppress repeat results on a non recurring result. Confused yet?

expression 1 returns "ASHIFT", "BSHIFT", "CSHIFT"-which I could use as they are, except that we do not want all the other misc shifts (admin, supervisor and so on) to list as they are, but rather as "OTHER"
So I have this formula setting that up:

if {sp_prod.(expression):1}= "ASHIFT" then "ASHIFT"
else
if {sp_prod.(expression):1} = "BSHIFT" then "BSHIFT"
else
if {sp_prod.(expression):1} = "CSHIFT" then "CSHIFT"
else
if {sp_prod.(expression):1} = "DSHIFT" then "DSHIFT"
else
"OTHER"

This information is grouped by shift (this formula), however they do not want the shift repeating itself for each person. Unfortunately for me the field does not realize it is repeating so I can not use the easy fix-suppress if duplicated nor if = previous. Is there any other way?

Thanks in advance!

 

[Turkbear]

Hi,
More design details please..
How is the report Grouped, besides the Shift?

If you group on shift before person it should solve the duplication problem.

 

[Jaedyn]

Thanks for the quick response

The report is kind of tricky-it is grouping by the shift and then the person and then the shift again. I do not believe it is a duplication issue-if it were that a simple suppress if duplicated would work. It does not know it is duplicating. I need a process/check that will tell it that it actually is a duplicate and then suppress it.

 

[lbass]

Why have an inner group on shift when the shift field will always be the same value because of the outer group on shift? I think it would help if you provided a report layout with some sample data, identifying which sections your data is in.

-LB