You're right! COM Objects and special reporting Objects should have their own set of classes. Even if they are based on the same data, the calculation is different, the purpose is different, the interfaces will be different. There is no easy way to do it.

I am using Excel as output with pivottables. It is a very good and easy way to let users create their own reports.

André

>André,
>It's really up to you. It sounds like your manager wants a number of reports that he/she can show to their manager.
>
>You can create a reports COM object and add functionality for all reporting through it. You could use it as part of of a reports system. Make the report engine data driven. The report form, report query and report filter criteria entry form could be included in a table and the report engine would parse all the information and display the report. You could customize a version of SF Query to handle this. You can get more information on this at www.stonefield.com.
>
>HTH.
>
>>Good morning.
>>I am developing a system in VFP based on COM.
>>I already built some COMs that access the data in my SQL Server.
>>These COMs represent a specific object in the database IE : the COM "Transactions" manage the "transactions" table. What I mean by manage, is that users can Add, Delete, Modify data.
>>
>>Question :
>>As you probably know, managers live only for Stats !
>>Since the COM "Transactions" manage the transactions row by row (IE in a grid in a form), how could I use that COM in order to create statistics ?
>>Can I reuse that COM or do I have to build another one for Stats purpose ?
>>IE : Manager question : "How many trans between these dates ?".
>>The COM I build manage Transactions on a real time system IE : users modify data right now. But the manager is asking stats for Months ago !
>>
>>Any ideas ?
>>
>>André Deshaies
>>Fimat Derivatives Canada Inc.