In the attached project I have a schematic and a report. The schematic only consists of a wire between two terminals, and both terminals have a manufacturer part associated. The report has two empty columns: "Origin PN" and "Destination PN". I am trying to get these columns to display the reference # for each terminal (94731-XTR and 94751-XTR), which is stored under the manufacturer part data.
There doesn't seem to be a direct way to do this without manually entering these as user data. I'm sure there's a way to get these numbers through "expert mode" in the Report Manager, but I haven't figured it out. How can I pull the terminal's reference numbers to use in my custom report?
I've attached a modified copy of your project archive which includes a report template that has this feature. Most of the out of the box report templates for cables do not join with the table that contains manufacturer part references (tew_buildofmaterial), so it needs to be added to the query manually, and for both the origin and destination sides of the connection.