Hello,
For years I have been using the CDate({trips.tdate}) = dateadd('d',-1 ,CurrentDate ) to batch print reports automatically utilizing Crystal Delivery. There has been changes to the report so now when I utilize the same formula it takes hours to run vs a few minutes. When I pick a specific date through the select expert utilizing the {trips.tdate} field the report only takes a minute or two but when I apply to formula it grinds for hours. The "accessing database" also takes a lot longer with the formula vs just a specific date. Any thoughts or guidance would be greatly appreciated.