Print Page | Close Window

Select Expert

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3621
Printed Date: 18 May 2024 at 1:38pm


Topic: Select Expert
Posted By: beth
Subject: Select Expert
Date 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?


Replies:
Posted By: jkwrpc
Date 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.
http://www.CustomReportWriters.net - www.CustomReportWriters.net


Print Page | Close Window