Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DateTime in record selection causes crash

Status
Not open for further replies.

wendal

Programmer
Feb 7, 2001
3
US
This one's got me stumped. Anytime I use the datetime function in the record selection, Crystal crashes. I'm using an oracle db and the table I'm accessing has about 80k records. I decided to segregate my formulas into separate functions and declare globals to hold the Date values. I used these values several places with complete success everywhere except the record selection function.

I am also using the BeforeReadingRecords and EvaluateAfter functions to ensure the values exist when checked.

My objective is to select records from 06:00 on a specific date (specified by large formula) to 06:00 on a specific date (usually CurrentDate).

Any insight on this matter would greatly be appreciated.
Thanks,
Wendal
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top