Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crystal Reports record selection formula?
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Crystal Reports record selection formula?
Miscellaneous
Thread ID:
00533482
Message ID:
00533482
Views:
25
This is the record selection formula in Crystal Reports for a report I am doing against a VFP table. My question is about the two lines where I check for blank fields. Is there a better way to do this? I am not sure the two lines are giving the expected result. It seems that those blank fields are making into my detail lines in my report. The fields are defined in my VFP table as Character 8. If they are empty or blank fields I don't want those records selected. Is there a better way to check for empty or blank fields in Crystal Reports in this particular formula?

My record selection formula:

{arrest.MD_INITIAL} like ["VF*", "VT"] and
not ({arrest.FDAPS_TIME} startswith " ") and
not ({arrest.FDFSH_TIME} startswith " ") and
{arrest.EDATE} in Date (2001,01,01) to Date (2001,03,31) and
{@totsec} > 29

Thanks very much!
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Next
Reply
Map
View

Click here to load this message in the networking platform