Hi Nick.

I understand you very well. Thank you very much.

I use to work with DBC and DBF files and i filter my records in the print button.click(), just before "report form" command. It works perfect, but my other problem is that when i'm going to design the report i need to add the tables to the report.DE and then, i have to delete them, because the same tables exist in my form.DE

My reason to do this is that when i have tables in the report.DE, i can drag fields from DE to report's bands, and it is easier than drawing fields and writing its names.

Can you tell me how do you use to design reports?
Thanks again

Juan Carlos

>Hello Juan,
>
>In this case I would probably not use the report.Dataenvironment.Init() for conditional filtering of the records for the report (or any other processing). I would do all the processing in the print button .Click() (which is on the form), and just run the report with no dataenvironment. My code usually looks like this:
>
>
>** cmdPrint.Click()
>local myParam1, myParam2, lcPreview
>lcPreview = IIF (NOT EMPTY(thisform.chkPreview.Value), "preview", "")
>myParam1 = thisform.txtMyCriteria1.Value
>myParam2 = thisform.txtMyCriteria2.Value
>
>SELECT * from Customers ;
>where Customers.cCountry = myParam1 ;
>and Customers.cState = myParam2 ;
>into cursor myReportCursor NOFILTER
>
>* some other processing may go here
>
>REPORT FORM myReport1 TO PRINTER &lcPreview NOCONSOLE
>
>***
>
>
>HTH,
>
>NIck
>
>