Print detail record only if one field is not blank 1

[stevesd]

How can I print a detail line based on the presence of data in some field, such as "Date Closed" I want a report listing customer names and account numbers, but only those with data in the "Date Closed" field. I am using CR 8, and Cache data bases through ODBC connection from CR.

 

[kenhamady]

Have you tried the select expert or the selection formula?

{CloseDate} > Date(1,1,1) Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[stevesd]

Thanks, Ken. Now how about that date format you have used. You used {CloseDate} to represent my field, but what is the Date(1,1,1) representing. I'm new and don't mind showing my ignorance.

 

[dcm]

Steve,

Crystal uses the serial date format as used in VB and so Date(1,1,1) would be better understood as Date(2000,12,27) i.e. Date(Year value, Month Value, Day value).

You may be able to use an alternative formula to determine whether the Date Closed field has an entry e.g. create a Valid Entry record with a formula of Isnull({Date Closed}} and select only where Valid Entry is False

David Monks

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[kenhamady]

Date(1,1,1) was a specific value that I thought you should use. It represents (essentially) the lowest date value (year 1, month 1, day 1). This will include any date in your report.

You will see the format required in the select expert if you pull down the sample values list and select one. You can then change any of the 3 values.

Putting in a specific value like the one I have shown is usually faster than using IsNull() since the function isn't usually converted to SQL in version 7. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[stevesd]

Ken, Thanks.
That is a killer formula tip. The {DateClosed} > Date(1,1,1) worked the first time.