CR 8.5, VB 6, using the report designer component inside of VB.
I have a report that uses two tables from the same database to create a report. The report uses criteria passed to it from a form in VB. The data retrieved is usually a couple of days worth of data, at most a couple of months. I ran the report trying to pull a few days worth of data and the report takes about 20-25 minutes to run. Is there anyway I can speed this up?
-In the report designer, under report options, I have the 'Use Indexes Or Server For Speed' box checked.
-I have 'Perform Grouping On Server' checked under the database object.
-My SQL Join Type is Equal[=].
I'm not sure what else I can do. Any suggestions.
I have a report that uses two tables from the same database to create a report. The report uses criteria passed to it from a form in VB. The data retrieved is usually a couple of days worth of data, at most a couple of months. I ran the report trying to pull a few days worth of data and the report takes about 20-25 minutes to run. Is there anyway I can speed this up?
-In the report designer, under report options, I have the 'Use Indexes Or Server For Speed' box checked.
-I have 'Perform Grouping On Server' checked under the database object.
-My SQL Join Type is Equal[=].
I'm not sure what else I can do. Any suggestions.