Exclude records from report

[Almie]

I am using Crystal Report 10 I would like to know how to exclude party that have a code "9750" posted to their docket. Sample data:
cs_typ cs_num p_typ p_num evnt_cd
CR 2003101 D 1 206
CR 2003101 D 1 9750

CR 2004122 D 1 206
CR 2004122 D 1 445


CR 2004345 D 1 9750

CR 2005443 D 1 445


Group 1: cs_type
Group 2: cs_num
Group 3: p_typ
Group 4: p_num

Party report results should be:
CR 2004122 D 1
CR 2005443 D 1

 

[synapsevampire]

Try Report->Selection Formula->record and place:

{tabledocket} <> "9750"

This assumes that you want them omitted from the report entirely.

-k

 

[Almie]

The Selection formula did not work, it only excluded that specific docket entry. I need to exclude that whole case.

In the sample data, I need the results to pull in only the cases that do not have "9750" as a docket entry.

 

[elsenorjose]

Have you tried modifying SV's code to {evnt_cd} <> 9750? It looks like that 9750 is an entry in the field evnt_cd, right?

 

[Almie]

Yes, 9759 is an entry in the field evnt_cd. I'm sorry...SVs?

 

[synapsevampire]

Group by the case.

Create a formula for the details of:

//@My9750
if {table.event_cd} = "9750" then
1
else
0

Now go to the Report->Selection formula->group and place:

sum({@My9750}),{table.cs_num}) = 0

This will then suppress the data, not eliminate it.

To eliminate it you might use SQL in a Command Object as the data source for the report which excludes those rows.

-k

 

[Almie]

IT WORKED! I AM SO HAPPY! Thank you, Thank you, Thank you.