DianaStewart
Programmer
I am running a report by typing in the url in the browser. I am using Access 2000 as a backend. The database contains 30000 records. A majority of the fields are indexed. My report contains 3 parameter fields, Name, Date1 and Date2...
Here is what I have in my Record Selection forumla editor:
{DB1.Date} >= {?Date1} and {DB1.Date} <= {?Date2} and {DB2.Name} = {?Name}
It takes excatly 2 minutes for the parameter fields to appear online and then takes a good 15 minutes to run the report... this is way too long ...
I am actually quite disappointed with Crystal Reports, this seems to be a very common problem... How can you ask a customer to stay onlione for 15 minutes waiting, waiting and waiting...
Any suggestions?
Here is what I have in my Record Selection forumla editor:
{DB1.Date} >= {?Date1} and {DB1.Date} <= {?Date2} and {DB2.Name} = {?Name}
It takes excatly 2 minutes for the parameter fields to appear online and then takes a good 15 minutes to run the report... this is way too long ...
I am actually quite disappointed with Crystal Reports, this seems to be a very common problem... How can you ask a customer to stay onlione for 15 minutes waiting, waiting and waiting...
Any suggestions?