General information
Category:
Reports & Report designer
Hi Liam,
I've had this same problem. It occurred when the print dialogue box went away reactivating the underlying screen which contained bound objects (expecially a grid!) Fox would then switch alias to redraw the object(s) wrecking the selected alias for the report.
I can't remember exactly what I did, but basically you to prevent the forms activation during printing. eg using a custom print dialogue modal window.
HTH
>Hi all,
>
>I have an odd problem with the reporter that someone may have come across before. Any ideas very welcome...
>
>Situation
>1) Numerous tables open...
>2) SELECT blah blah blah into cursor CurRep
>3) REPORT FORM blah blah blah
>4) Report is fine until I move to the next page or zoom in or out then
>I get an error message not found
>
> is one of a few variables in the report that is causing the error.
>
>After investigating (and much hair pulling) I discovered that VFP is SELECTing a table other than the result of the SQL statement (CurRep) DURING the report!
>
>Before the REPORT FORM command I inserted a messagebox(alias()) command to confirm that the correct table is, in fact, selected. A further messagebox(Alias()) command after REPORT FORM (and usual errors) will show that a completely different table is selected.
>
>Explicitly SELECTing the Cursor after the SQL statement makes no difference.
>
>During debugging I also discovered that if I issue a BROWSE before the REPORT FORM command, everything will go fine and the correct table will remain selected.
>
>Anyone seen anything like this before ??
>
>TIA
>
>Liam
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only