Skip to Content
0
Former Member
Feb 26, 2009 at 10:14 PM

How to mimic 'NOT EXISTS' in Crystal Reports XI R2

1049 Views

I have a Report that I want to mimic the NOT EXISTS clause in Crystal Reports XI R2.

I have a Report that uses Business View Manager linked to Oracle 10g database.

I am only using the Main Survey Table Only in my Crystal Report.

If the ProductID Parameter is ...ALL then I want all of the main records selected.

Else

If the ProductID's are selected and they exist in the One to Many Table then the associated main record is valid else do not print.

Main Survey Table (One to One) and SurveyProduct (One to Many) Table both have SurveyID as their common field.

Any Suggestions?