Ravi,

My suggestion is to JOIN (using SQL-Select) all the data together into one cursor before calling the report. Also, you won't need to use the data environment of the report if you use this approach.

You will probably have repeating information in your cursor, but that is okay...

>Hi all:
>
>My report will require information from 3 different tables. Currently, the way I am approaching it is:
>
>1. Select * from table1 into cursor curTable1
>2. Select * from table2 where a field in table1 matches a field in table2 into curTable2
>
>In the report, I placed the client name in the header (did not create groups), since the report is for a specific client and for a specific date. In the detail section, I placed labels for the fields and linked them to fields in curTable1. The display was OK to this point.
>
>Then I added a field in the report and linked it to a field from curTable2. At this point, the report showed all of the info from curTable1 and one value from a field in curTable2. Then, it followed by repeating the fields from curTable1 and then displayed the new value for a field from curTable. I do not want curTable1 field repeating each time.
>
>Any suggestions? TIA.
>
>Ravi