formula eval time

[kaiso]

Hi all;
I am using CR8 with SQL7. My report is linked to 1 table in the database. I am creating a date range variable in my formula as such:

BeforeReadingRecords
datevar d ;
datevar range dr ;
d := cdate( DateAdd ("d", -45 , CurrentDate) );
dr:= DateSerial (Year(d), Month(d) , day(d)) To
DateSerial (Year(d), Month(d)+1, 1 - 1) ;
d

This will be used to provide a date range within the Record Selection Formula Editor to restrict the number of records pulled by the server.

The problem is the formula above is not evaluating until all the records are selected on the server....

help....and thanks.

 

[kenhamady]

Typically, if you use a function in the formula, Crystal can't convert it to SQL. This would force it to read all records and have the selection processed at the client.

Ken Hamady

http://www.kenhamady.com/

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

 

[kaiso]

Thanks for the help Ken. I will try using sql expressions ??to avoid the conflict.