Special Formula

[aspnet98]

If someone could show me a way to do the following it would really help!

I have the following data set.

ID Type AMT
1 THE 10
1 123 12
2 THE 10
3 000 0
4 THE 10
4 456 12

I need to show the following:
IF the type = THE then show all records with duplicate IDs:

This is what should show...

ID Type AMT
1 THE 10
1 123 12
4 THE 10
4 456 12

I do not know how to acomplish this in crystal. We can not use any sql commands b/c my db prevents it.

CR 8.5

Any ideas or suggestions would be great!

 

[lbass]

FIrst insert a group on {table.ID}. You can suppress the group header and footer if you wish. Then create a formula {@THE}:

if {table.type} = "THE" then 1 else 0

Then go to report->edit selection formulas->GROUP and enter:

sum({@THE},{table.ID}) > 0 and
count({table.ID},{table.ID}) > 0

-LB