Hello, everyone.
I'm hoping someone can assist me with adding an SOP User Defined field to our statements.
I have Report Writer and templating all figured out--to a basic level at least. What is tripping me up is getting the SOP User Defined X fields I want to actually show data when I run the statements. Any other fields I want seem to work fine, but specifically the User Defined just remaind blank.
I have ensured the table is added to the report and that a relationship exists--I tried both the RM Open File table and the RM Statement Transaction Temp table, by linking SOP type and SOPNUMBE to Document ID. Validate does not complain, but yet my fields remain unpopulated in my reports.
If anyone has slain this particular beast and can give me the secret to linking tables to the 'current file' in a situation like statements have, I would be estatic.
Somewhat frustrating to have so much trouble doing something is report writer that is so trival in SQL or Power Query....