Save yourself lots of problems...and make your report run faster. Do all your record selections in VFP and pull the report data into one or two cursors, then COPY TO TYPE FOX2X. Base your CR on that.
>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!
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer