Speed of Opening Reports

[KishSays]

I am Using VB6.0 and SQl Server. All the reports are developed using Crystal Report Designer Enviroment and saved as .rpt files.
From VB i just specify the filename, Provide the Connection string and use
CrystalReport1.Action = 1 to open the Report.
The Report takes a long time to open(Since lot of time is taken in connecting to the database) even if there are no records.
same process is Followed to open different reports using different Crystal Report OCX Object.
Is this the right method. If No then please suggest me some way open reports in Quick Time.

Can Embedding the Crystal Report in VB be a solution........

 

[Ngolem]

the time to open of the reports is usually based on the query that gathers the data. The more efficient the query the faster the report opens. This of course is related to how efficient the database is in the first place and the use of index fields etc...

Embedding the report in VB does not speed things up IMHO Jim Broadbent

 

[KishSays]

I think more time is taken in connecting to the Database rather than Query....

Once the Report is opened the opetration of Quey Starts..

I suppose there is some other method...........

 

[Ngolem]

there are a lot of operations camoflagued under the label "Opening Database" Jim Broadbent