I am trying to add a table to PartTran. I need to add the NonConf_CommentText field to the Non-Conformance Report. Getting crossed up on the SSRS report.
Relationship Fields
I’m confused - which Report Style are you trying to amend? Is it the one called “PTranLog” and you’re wanting to link from the NonConfID field in PartTran table to the NonConf table to get the Comment?
In your screenshot you’re showing an invalid join. You need to be joining Company = Company (like you have), and then NonConfID = TranID or you could possibly join based on Job or DMR also.
There are some good references on EpicCare for joins with PartTran and TranGLC tables. It would be worthwhile to take a look at these as well as the data dictionary and try to make your linking match one of the keys. These 2 tables are typically the largest in the database and improper joins greatly impact performance.
Jenn
1 Like
I was trying to join based on job #
Which Report Style are you working on?
nonconfinvmvmnt