crystal report -- frustrate!

[alanchinese]

we have a complicate report file built from Crystal Report 8.
the report is connecting to SQL Server through ODBC driver, and selecting from two huge joint tables.

here was what i have done:

* load the report file into ReportDocument (namely oRpt),
* sepecify the oRpt.RecordSelectionFormula property as what is copied from the selection expert in the real crystal report program.
* reportviewer.reportsouce = oRpt

this works in a simple test file, but when it gets the complicate huge tables, it takes forever to load the report. however, the real Crystal Reports program takes only one minute. i wonder if the .net ignores the RecordSelectionFormula and tries to select the whole table.

if not, what should i do to rapidly load the report into the reportviewer?

or let me make it simple, i just want to pass in the parameter and export the report into a pdf file, even without the reportviewer and do everything in console is ok?

thankx for your help... it really made me frustrate coz i dont know where to get more information.