Report Manager - Showing Change Requests and Affected Data

[borourke]

Has anyone through the Report Manager built a report that shows Change Requests and their associated affected data? Specifically, a user wants to see a report of our CRs with the names of the affected items. I am trying in the Report Manager, but cannot get the link between the cr table and the epmdocument table right. Any help would be most appreciated. Thanks in advance and Happy Mardi Gras!

Send lawyers, guns, and money...the sh!t has hit the fan!

[dwilliams]

Hi Bill,

I'm assuming your only concerned about the associated EMPDocuments?
Try joining the wt.epm.EPMDocument and the wt.change2.WTChangeRequest2
with a Relevant Request Data link.



HTH,

Dax Williams
Engineering E-Tools Administrator
GE Healthcare OEC

Surgery