I am a relative Newbie to Crystal Reports and have a question. When I run reports against my SQL database it seems like tons of records are being filtered by my pc. The status bar at the bottom of the screen shows something like 2032 of 2345678 records. Is there a way to get the sorting done on the server so I'm not getting 2345678 records sent to my pc for filtering? I'm looking to speed up the reporting process.
The formula that the Select Expert shows is:
{@StartTime} in DateTime (2008, 02, 13, 17, 30, 00) to DateTime (2008, 02, 14, 00, 01, 17) and
{SCDR.Phone} = "2077450315"
Thanks,
IP Logged
