Joined: 27 Feb 2007
Location: United Kingdom
Online Status: Offline
Posts: 2
Topic: Exclusion of data within a report - newbie 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.
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
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>
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
