>>With regular single band report, i use to do a SELECT SQL....INTO CURSOR myreport AND then do my report based on the fields from the cursor myreport.
>>
>>I am trying to do the same with multi-band vfp9 reports without success:
>>
>>example:
>>SELECT idclient, name FROM arclient INTO CURSOR myreport
>>SELECT invoiceno, amount, idclient FROM arinvoice INTO CURSOR mysubreport1
>>SELECT myreport
>>SET RELATION TO idclient INTO mysubreport1
>>
>>In the property of the report detail band, I put 'myreport' and 'mysubreport1' in each of them.
>>When I run, it says 'mysubreport1 does not relate to the current work area'.
>>
>>I think there is something I don't understand.
>>Any idea
>>
>>Many thanks
>
>You need an index on idclient in myreport.
Mange takk. Jeg skal prøve det.