>I have some reports based on queries. I send them to preview before printing but when I click the print icon it replaces the tmpcursor data with the table the select statement was based on, then it prints out the entire table with the report header neatly placed on top of each page. I make sure the cursor is selected yet it prints the table which is not in the selected work area. So, I decided to try the to printer clause in my report form command. Now it paints the report inside the active form with the cursor data, no print. There is no set device commands anywhere in the program yet it paints the active form with the report when I use the clause TO PRINTER PROMPT.
>Is this normal?
>
>Eric K.

If your form's datasession is set to 1-DEFAULT, check it out on the DEACTIVATE EVENT of the form if you have some SELECT mytable statement. There is a possibility that the desired select workarea you are supposed to print was interchanged with the SELECT mytable at DEACTIVATE EVENT when the PREVIEW fires. Remember, DEACTIVATE EVENT of the form to be left fires first before the ACTIVATE EVENT of the FORM being called. This happens when your FORM's Datasession is set to 1-DEFAULT.