How long should it take for the following report to run?

[aaronburro]

This is el-simple-o report, and its meant to be.

System is MAS200, non-SQL

CustomerNumber
list of all invoices for that customer

Group by CustomerMaster.CustomerNumber

No record selection formula
Total number of Invoices: ~4100
Total number of Customers: ~1000
Linking:
CustomerMaster.CustomerNumber (equals)--> InvoiceHistoryHeader.CustomerNumber

I realize that the "smarter" way to do this would be not to use the CustomerMaster table, but I'm doing it for the purpose of evaluating a possible "bottleneck."

thx in advance

 

[dgillz]

Seconds.

Ask your Mas90 reseller to run the same report for Mas200 (SQL database) and see the difference.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[mrstnturner]

Are you have the report do the grouping on the server?
And to supress if no records?
It could be an overall linking error.

 

[aaronburro]

I found out the problem, mrstnturner. Among other things, I wasn't linking by a whole key (stupid teacher at the CR class told me to only link to the FIELDS that were required to ensure unique records), and that caused a HUGE slowdown. as a result, having the "use indexes or server" box checked made Crystal appear to jam, so I unchecked that box. Added insult to injury, really. I'm good to go, now, on the whole thx, though.

as an aside, I haven't noticed a large difference in speed when having Group on Server checked. should I expect a difference?