hi,
when i try as
report form ser to print && it works
but i need to see it before printed
thanks
>Add NOFILTER at the end of the select statement.
>
>>hi all,
>>
>>i try via this code to print myreport , via preview i see the result i select, at paper another result.
>>

>>
>>LOCAL ldStart, ldEnd
>>ldStart = thisform.pageframe1.page3.text12.value
>>ldEnd = thisform.pageframe1.page3.text2.value
>>  M.QA=thisform.pageframe1.page3.text5.value
>>    SELECT  TAlias5.endat,TAlias5.date1,TAlias5.roomno,TAlias5.place1,TAlias6.mobile,TAlias6.tel,TAlias6.empname, TAlias5.discerror,TAlias5.sno,TAlias5.mark1 ;
>>         FROM trans1 TAlias5, emp1 TAlias6 ;
>>           WHERE  TAlias5.empno = TAlias6.empno   ;
>>             and TAlias5.fexerno=val(M.QA) AND BETWEEN( date1, ldStart, ldEnd )  AND TAlias5.mark1=1 ;
>>               ORDER BY date1,sno ;
>>                 INTO cursor  mycur22
>>   BROWSE
>>**result ok, TAlias5.mark1=1
>>SELECT mycur22
>>**result ok,TAlias5.mark1=1
>>
>>REPORT FORM ser PREVIEW
>>**another result for same sno but TAlias5.mark1=0
>>
>>**i put at my report detail thisform.pageframe1.page3.text12.value, thisform.pageframe1.page3.text2.value ,thisform.pageframe1.page3.text5.value
>>and thisform.pageframe1.page3.text6.value
>>
>>**at detail  i put sno and empname
>><\pre>
>>
>>thank you