suppress group not having two codes in detail 1

[cbriell]

Working with crystal 8.5 on an Oracle 7.

In referring to thread149-1011694, I have a report that is similar, but I would only want to show the groups with 990 and 910. I would want to suppress those groups that did not have both.

Thank you in advance for any assistance. I can't tell you how many times this forum has helped me.

chris

 

[synapsevampire]

If you only want those groups, you basically remove the NOT from LB's solution:

Group on {table.employee} and then create a formula {@910990}:

if {table.paycode} in [910,990] then
1
else
0

Then go to edit selection formula->GROUP and enter:

sum({@not901990},{table.employee}) > 0

-LB

 

[cbriell]

I apologize for not providing enough info. I can't seem to put this situation into words that even I can understand.

I made the change you suggested, but it doesn't suppress the groups that I would expect. The groups I want to see must have 990 and 910 in the same group. If it has just 910, I want to suppress. Same with just 990.

I know this is cryptic, but I hope you have those special powers to read my mind....

Thanks again.

Chris

 

[synapsevampire]

Ahh, must have both coondtions, got it.

2 formulas:

@910
if {table.paycode} = 910 then
1
else
0

@990
if {table.paycode} = 990 then
1
else
0

Then the group selection is:

sum({@910},{table.employee}) > 0
and
sum({@990},{table.employee}) > 0

-k

 

[cbriell]

Thank you so much. That worked perfectly!

Chris