I have been asked to add the Reason Code to the Inventory/WIP report. Someone already created a custom RDD I can work with. I see reference is on the report as TmpReference and I’m not sure how that is being calculated. Anyone have any suggestions on how to link either PartTran or Reason to this report?
What a disaster of an RDD. Does it seriously not have any fields in it whatsoever to link to anything? Sorry - I thought I might have some insights but looking at the RDD and the RDL file, it’s a mystery. Even if those fields were present on the RDD, there’s no TranNum that I can see so I’m not sure how you’d go about linking it.
I have not modified the Inv/WIP RDD specifically but in other RDDs with these calculated/temporary tables I have had luck using the Table Criteria or Relationship tabs to see the list of available fields in the RDD without actually seeing them in the screen. You can also generate the report for design and (if you have access to your database server) you can look up the fields and data actually exported by the RDD.
If you can’t find a field to join on the RDD data, you can add the Reason table joining by only Company to get the full list of Reason Codes and then try to join the data in the RDL file.
3 Likes