You’re offline. This is a read only version of the page.
270
I have a report based on
InventCostTrans
>InventTrans
>PurchLine
Relations are defined as InventTransId between tables
When the report runs the InventTrans and PurchLine data for the first row appears on the second row and continues to be one row out.
example:
ItemNo for A <BLANK>
ItemNo for B ItemName for A
ItemNo for C ItemName for B
etc
I have attached a report where I have added the InventTransId to the end of the report page (right) to show the misalignment as it isn't clear in the report that the data is not correct.
Any ideas what I am doing wrong ?
*This post is locked for comments
I have the same question (0)
This problem is cause by your report's design structure. Be aware the the report fetch's each table in the execute section method.
Restructure your report's design as follows:
Body:InventCostTrans (Table Property=InventCostTrans, No fields - just the body)
Body:InventTrans (Table Property=InventTrans, No fields)
Body:PurchLine (Talbe Property=PurchLine - place all your fields in this body)
The report will then call
Body:InventCostTrans/methods/execute section to read the correct InventCostTrans record
Body:InventTrans/methods/execute section to read the correct InventTrans record
and finally
Body:PurchLine/methods/execute section to read the correct PurchLine record
Once the report enters the last body, fields can be added from any of the data source tables and will show the correct values.
Share
Report
All responses (
Answers (
