Hi goran 

Thanks for ur help, well finally i used 
queries and union queries for the statement 
of account report, it took about 7 or 8 queries
to do the job but it worked.

About collections i wished we can bind it to 
the crystal report, but i think it can't be done.

Thanks for ur help

Michel Medawar
> 
> From: goran.osterman@t...
> Date: 2001/12/18 Tue PM 01:31:32 GMT+02:00
> To: "professional vb" <pro_vb@p...>
> Subject: [pro_vb] SV: Statement of Account
> 
> Michel,
> 
> I'm sorry, I have very little experience  using a reporter (and none using
> Crystal). As far as I understand, the normal processing in reporters is
> based on recordset. Without any doubt, you should be able to add calculated
> and other info from local variables. The problem is I don't know how that is
> done.
> 
> I assume you have no intention of rewriting the reports. If you did, you
> would have no problem using classes and collections to produce the reports.
> My problem is, I don't know how to bind a collection to a Crystal report, or
> if it's possible. Maybe someone with better experience can guide us?
> 
> If it's possible to bind a collection to your reporter, I would recomend
> that option. An alternative, is to produce a recordset solely for the
> explicit report. This can be done from a collection, but would be quicker
> through SQL (quickest by creating a stored procedure). But then again, it
> depends on how you use the system. For example:
> 
> 1) A user is uppdating info and choose to produce a report. Using
> collections would suite both functions.
> 2) The specific reports are produced at specified occasions. You would NOT
> benefit from creating collections. Use recordset!
> 
> Hope this shed some light.
> Regards G?ran
> 
> -----Ursprungligt meddelande-----
> Fr?n: Michel Medawar [mailto:mmedawar@t...]
> Skickat: den 14 december 2001 21:04
> Till: professional vb
> ?mne: [pro_vb] Re: SV: Statement of Account
> 
> 
> Hi Goran
> 
> First thanks for your help,
> 
> 1) About producing the report, i'm using the crystal
> report as a reporter, usually the process of opening
> a report is first opening a recordset in VB based
> on a query or stored procedure then binding this
> recordset to the report.
> 
> 2) About the future, yes i have many other accounting
> reports like balances and other to make, so i'm planing
> to work it right even if it took some extra time.
> 
> 3) Let's suppose i used collections class, will i be able to bind
> it to the crystal report? or what do u use for output?
> 
> Waiting to hear from you soon.
> 
> Best Regards.
> 
> Michel Medawar
> 
> 
> 
> 
> 
>