General information
Category:
Reports & Report designer
Title:
Parent-child report problem. Wrong area is selected
Hello ,
I have a very big problem .
Two tables: parent and child: "invoice" and "invoicep" . I have a report which contains in the header data from parent table (invoice) and in the detail contains records from child table (invoicep) .
THE BIG PROBLEM is that sometimes, the report returns error that a variable from report detail is not found (ex: 'Variable "quantity" is not found' ). Quantity is from child table (invoicep) . And I established catching the error that the cursor is on the parent table at the moment the reports writes the detail.
I have to say that before the REPORT FORM command I selected the child table and in report header the fields' variables are specfifying the parent name, like "invoice.client" .
The code is like:
SELECT invoicep
REPORT FORM ...
So the detail should be on invoicep cursor when writing the report .
VERY IMPORTANT. I have to say that the _screen object has a timer, which action does some operations, including "SELECT invoice" command .
I think this could be a reason. BUT, if the code selects the right table, how could the area change between the two lines , even if the timer's action is executing. I think the timer doesn't execute during the report .
What other reason could be ? Or how can I do to be sure that area won't change during a report ?
Thanks a lot !
Mihai .
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