Hi Mohammed,

I did not get your question, sorry, try to explain again. It looks like you have multiple tables you want to show information from. If so, you have to join them in your select statement on the primary - foreign key. You still have to use a single cursor to drive your report, because it is much easier this way.

Do you have problems writing the select statement for your report or problems with report itself? If the former, then we need structure of your tables, if the latter - then you need to describe your report layout.

>hi,
>thank you very much,
>
>at myform i have textbox to get the item i want to see all bills,
>to show that i have a grid1,becuse some times i have the same name with small differnt,as al007 and al007P,
>if i choice one of this items,i get new (grid2) to see all bills
>your code get the first record only from mygrid2,becuse myreport data at page header maybe,
> i put my data at page header becuse i need to preview ex... one bill every click,when i choice from mygrid2.
>
>any advice
>

>
>local lnPK as Integer && assuming integer PK
>lnPk = trans1.no && put the name of your primary key field, it will get the value from the currently selected record in the grid
>select * from trans1 where no = m.lnPK into cursor curToReport nofilter
>thisform.cmdPrintReport.SetFocus() && you have to move focus off the grid to another object before printing your report
>report form trans1 Preview
>thisform.grid1.setfocus() && restore focus back
>

>
>best regards
>m.qasem