Supression of both entries based on existence of one

[sap1958]

I am using crystal 2008 and want to suppress both entries that appear vertically on a detail line. Here is an output example:
ID NAME SCHOOL CONCENTRATION Conc Code
1 John Mass Comm Mass Comm 6
1 John Mass Comm Advertisment 5
2 Samuel Mass Comm Creative Design 1

In this example, Because John has a degree in Advertisement or conc code 5 I want to eliminate both his Mass Comm and Advertisment and eliminate John altogether. Remember the data appears vertically on the detail line. So in this example the only entry that should appear is Samuel. How would I accomplish this in a crystal supression formula

 

[Madawc]

You want to eliminate everyone in Advertising, right? If you only want one entry for the person, group by person and do a running total for 'Advertising. Suppress the detail lines and group header. Suppress the footer if it has a non-zero count for Advertising.

(Note that you may get null, test for this first.)

If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

PS. You could also use a summary total for 'Minimum', assuming 'Advertising' is the lowest thing on your database. Then you could use Group Selection.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[lbass]

Group on ID and then create a formula like this:

//{@has5}:
if {table.concode} = 5 then 1

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

sum({@has5},{table.ID}) = 0

Then you will need to use running totals for any summaries across IDs, since non-group selected records will contribute to the more usual inserted summaries.

-LB