>Hi,
>Where is the best place for custom code for report generation, ex. custom code that UNION 2 cursors.... and it should be able to called from other like web or...
>
>Thank you
I've got a customized object that I subclass from for all of my reports. It has a standard interface I use for all of my reports. In each subclass, I add properties needed to filter, group, etc. the report (for example, my baseclass report object has a dStart and a dEnd property since most reports need to filter on a date range).
From within my report object, I call out to various bizobj's to generate the cursor necessary to run my report. This gives me one place, like a normal business object, where I can generate reports. This works very well - I've got a few apps. where I call the same object to generate reports from both a desktop app, and a web application.