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