Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: Select Expert Post Reply Post New Topic
Author Message
beth
Newbie
Newbie


Joined: 07 Jul 2008
Location: Australia
Online Status: Offline
Posts: 1
Quote beth Replybullet Topic: Select Expert
    Posted: 07 Jul 2008 at 11:17pm
I'm brand new to crystal reports (i've tought myself the BASICS) but am having trouble using the select expert.  I'm trying to run a report WITHOUT the contacts that have been expired in our database.  Stupid question . . . but how do i do this?
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 11 Jul 2008 at 12:05pm
You will need to know how an expired contact is recorded. If it marked expired then you would use a does not equal that criteria. If it is a date then it would be everything greater than that date. If it is date that varies and is only recorded when a date or value when the contact expires then you would compare to an empty or null value.
 
if x is expired then this might take one of these forms.
 
x <> y (expired indicator
x > 07/11/2008  ( looks for a date after)
x IsNull or x = "" ( looks for a null if that is what is in the data or empty field.
 
Hope this helps you can find more information in CR Help I believe it is under operators.
 
Regards,
 
John W.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.031 seconds.