>>
>>James,
>> I scoured through the manual and found little information for building data enviroments for reports..
>>
>>Could I ask you how you handle reports in the framework? I mean in more detail, since I know we will have to do some mundging of data to create the reports that people want..
>>
>>A simple data enivioment might noot suffice, since some reports are built using a few pages of SQL Selects!!
>>
>>Thanks!
>>
>>Tony Miller
>>Seattle City Light
>
>Tony,
>
>Open the Developer's Guide and do a find on Overview of Reports. There you will see a discussion on Reports and report dataenvironments. When you create a new project using quick start, a dataenvironment class is created for your reports. Once you read that section, you will find all kinds of new ideas will open up for you. The manual leans towards using views with your report objects, but you could include some tables and simply run some sql. The options are many. If you are running a report based on information displayed on the form. You could open all the cursors using a delogical object and run the sql.
>
>A more encapsulated approach, and one I have used before, is to create a custom report object that reads the path information to your data from either the registry or your metadbc. From there you can run some custom methods to query the data directly. This approach works for local and remote data if you build it correctly. If it's remote, you send the sql in as sql passthrough. If it's local, you simply run the sql.
>
>Hope this helps.

James,
I see so far.. but in looking at the manual it seems to skip a portion of the data enviroment building.. I looked at the sample that comes with MM, the project manager app, and the one report they have has the following:

A report called projecttask, so they build an enviroment called projecttasksreportenviroment.. In this container object is a dynamicviewcursor based object.. How does this get added to the subclassed report data enviroment?

The documentation for reports says to look at the documentation for building data enviroments...Normally when building a data enviroment, you use a builder in conjunction with a bizobject to build the data enviroment..

So, if I am making this too hard, please let me know.. I have subclassed the application specific report data enviroment, stored it in the same class library as other data enviroments.. The report form data enviroment code has been modified per the documentation, yet when the report is run, the app can not find the subclassed report data enviroment..

Thanks!

Tony Miller
Seattle City Light