>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
Thanks Steve. Take a look at what I sent Sergey.
Ravi
- Ravi
True greatness consists in being great in little things.
- Charles Simmons