>>Hello,
>>
>>We are using VFP 6.0
>>We have to make a report of a company and also in that report the board of the company and the changes over the years of the company must be shown.
>>
>>So it is possible that there are more then 1 member in a board and more changes has taken place in the company..
>>
>>that's why we need the detail in the report. But we need two 'details'
>>
>>Is it possible to have two 'details' in one report?
>>
>>Greetings
>>
>>Wiebe Blankenberg
>>Using the account of Koos Veel
>
>You may squeeze all related data to one cursor and use it for report form.
I ran into this problem a couple months ago. I couldn't figure out how to get everything to sqeeze into one cursor. It was possible to have 20 records for one detail and 10 for the other or any odd combination like that. I couldn't figure out how to join the two groups when there weren't the same number of records. I thought maybe it could be done with some kind of right,left,inner,outer join of some kind, but I don't know how to do that. I also was using VFP 3.0 and I am not sure if it can do those type of SELECTs anyway. So what I did was just create a temporary table that had a field for each possible field in each possible record, so that I ended up with a table that could hold all the records from the one detail group in one record. Then I related that to the parent table put this fake detail group in the header, and the other real detail in the detail band. It was kind of clumsy but it worked.
Shane
--Shane