Forumula to supress records
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22571
Printed Date: 26 Apr 2024 at 9:27pm
Topic: Forumula to supress records
Posted By: dan231
Subject: Forumula to supress records
Date Posted: 10 Apr 2018 at 3:41am
I have found a few posts on this, but I'm probably not fully understanding how this works...
I want to suppress certain records from my report. I can put a IS NOT in the select expert, but then it is stripping too much data.
My issue is that I am linking on application number, but I only want who sold insurance on the loan. This table has anywhere form 0-5 different items listed per each application number.
When nothing is suppressed, I think my data is wrong as the ins sold by is blank, when the table has data. But then when I suppress, the loans that were did not have ins sold are suppressed completely, when I still want those listed.
Suppressing from my formula is doesn't suppress anything and suppressing from the select expert suppresses to much.
-------------
Thanks,
Dan
|
Replies:
Posted By: lockwelle
Date Posted: 23 Apr 2018 at 10:27am
It sounds like the data is incorrect to begin with...a join is off or some other filter is being applied that blocks the records that you are after.
I think that once you can see the records that had insurance sold correctly, try the suppress again. If it is coming out blank when it should not be, that usually points to a join condition being incorrect.
HTH
|
|