Dear All,

I do have a question on the report which I need to create, but first I have to know on such report generating, ie, cycle time, data extraction method for the data which contain the following information :

no of customer	no of day	no  of store	no of sku	1 year turnover	2 year turnover
33000	365	10	1500	180,675,000,000	361,350,000,000

 
Base on this I need to create the following report :

By sales person
by store
by customer group
by product group

Details of customer purchase
Details of product sales


All report by RM & Quantity

I would like o know, the processing time for the report retrieve from SQL server by Crystal Report. Since I never do such huge data report before. I'm worry this will slow down the report processing run time.  This report need to retrieve everyday by customer.

Can anyone advice me how do I plant and do the report, should I run store procedure, or run sql command, or using programming style to create report.

Thanks and regards
Shiloh