>
>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.