CR in VB.Net Using Large Data Table

seabiscuit · July 6th, 2004, 02:10 PM

I created a Crystal Report in VB.Net that displays amount totals grouped by account number. The detail section contains no data so only the summary totals display. Since the MS Access table is very large, the report takes over 10 minutes to display on the screen. At run time, an ADO dataset and report document object is created. The dataset is filled (Select * from myTable) and then used as the data source for my report (reportDoc.SetDataSource(myDataset)). Is there any way to speed the display of the report if I only need the summary totals without the detail?

Thanks for your help!

melvik · July 7th, 2004, 12:28 AM

try:

Code:

SELECT Sum(urField)
FROM myTable
GROUP BY [u]account number</u>

if u wanna have only that sum.

Always:),
Hovik Melkomian.