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 don't know where to get more information.