Best way of compiling report data???????

[ConvertFromOldNGs]

by skipton >> Tue, 6 May 2003 9:36:59 GMT

I want to compile a report which is basically tallies of various criteria and tied to searchable keyed objects. What is the best way to do this ?

I did a prototype of having a temporary report class with the keyed object (mySubProduct) and then integer attributes for the tallies. I created entries for all subproducts and then went thru all my main transactions and built up a store of tallies against each subproduct. I could search for the correct object using getAtKey.

This approach worked fine -- but of course is single user with making use of a single temporary report store. How should I do a similar report run but faiclitating multi-user report sessions ??????????

Thanx in anticipation
Silversprings

[ConvertFromOldNGs]

by allistar >> Tue, 6 May 2003 10:35:42 GMT

Hi there,
I assume that this temporary report store is stored as transient objects, in which case there should be no multiuser issues (i.e. more than one user should be able to run the report at the same time).

To make the report much faster another way is to actually store these tallies in the database as the objects (SubProduct instances, by the looks of things) get created. Each time one of these things is created/deleted, or one of the variables being tallied is altered, adjust the stored tally accordingly. That way there is no need to work out the tallies each time the report is run as the tally data is maintained online. (We use this approach for quite a few parts of our system to greatly improve enquiry and reporting time).

Hope this helps,
Allistar.

------------------------------------------------------------------
Allistar Melville
Software Developer, Analyst allistar@silvermoon.co.nz
Auckland, NEW ZEALAND

Silvermoon Software
Specialising in JADE development and consulting
Visit us at: http://www.silvermoon.co.nz ------------------------------------------------------------------

[ConvertFromOldNGs]

by skipton >> Wed, 7 May 2003 9:44:14 GMT

Any personal replies to this original post please direct to alan.thomson@skipton.co.uk --- as goodness knows where pressing the <Message Submitter> button on the browser version of this newsreader will send things !!!!