Post Author: pcObelix
CA Forum: General
Crystal Reports XI
I have a report that I want to limit the output based on information on a subreport and am having a great deal of difficulty achieveing the desired result.
There are 2 seperate reports, of which one works but the other does not.
The report that works, using an "if like" selection criteria, and works beautifully.
The second report, I want to exclude data, and cannot get it to do it.
3 files
1. Books
2. Book-Subjects
3. Subjects
One book can have multiple subjects. The subjects data is the subreport data, as it wass the only way to get the information into the report without duplicating information in the main body of the report.
What I want to be able to do is exclude subjects, and have it not print the entire book record. At the moment, if I tell it to not include specific subjects, it will not print them, but it will still print the book details, which is not what I want.
I tried using the opposite philosophy of the report that works, which has an if like statement, and that will print the book details no matter if the subject to include is the first of second or thrid related entry in the subjects file.
I tried to do a suppress criteria but could not get this to work either.
Any help would be appreaciated.