Print Page | Close Window

Exclusion of data within a report - newbie

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=248
Printed Date: 03 May 2025 at 12:10am


Topic: Exclusion of data within a report - newbie
Posted By: altbunny
Subject: Exclusion of data within a report - newbie
Date Posted: 27 Feb 2007 at 9:37am
Hi,
I am new to Crystal Reports so please bear with me.
 
I wish to display all id's from within a table but wish to exclude 5 depending from within the table.  How do i write that within the Record selection formula editor?
 
So the fields i want to exclude have the id's: 514,496,516,584,586.
 
Thanks
T.


Replies:
Posted By: BrianBischof
Date Posted: 27 Feb 2007 at 10:29am
To exclude values in your report selection formula, select the menu options  Report | Select Expert. Then select the field to filter on. In the drop down box for criteria, choose "Is Not One Of", then on the right pick the values you want to exclude.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: altbunny
Date Posted: 28 Feb 2007 at 1:06am

Thank you for your reply.  How would I write this directly in the Selection statement within the "Record Selection Formula Editor"?

 
Thank you again for your answer.
 
T.

Posted By: gharisuresh
Date Posted: 01 Mar 2007 at 2:36am
Not {tabname.Id} In (514,496,516,584,586) in the record selection formula

-------------
Suresh


Print Page | Close Window