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
