CN with CR's overview

[DV_10922158]

Version: Windchill 12.1

Use Case: I am trying to create a report showing all Change Notices together with their associated Change Requests. The CR's are associated in 2 different ways: - Associated Process Objects - Associated Reference Objects I want to create an overview were both associated types CR's are shown. If possible it would be nice to show the association type in the overview as well

Description:

I can't get the report to include both link types in one overview.

If I create two reports: 1 for the Change Process Link and 1 for the Change Reference Link and merge the two in excel I get wat I want but I think this should be possible in 1 report....

I also found out about the option "Outer Joint Against" you need to set this correct to also show CN's with no CR's associated to it. Is there a way to show both:

- the CN's with no associated CR's

- the CR's with no associate CN's

Any good tips to speed up my learning experience are welcome. Courses / books / websites....

Best regards,

Dennis Varkevisser

[Marco_Tosin]

This is a good start point to learn about reporting

ptc.com/en/support/wnc-reporting-landing

Here a generic HUB article divided in section

[Knowledge Hub] Windchill PLM -Business Reporting

Here something similar to your needs

[QML] Report listing all Change Requests with/without an associated Change Notice in Windchill PDMLink

[anursingh]

Hi @DV_10922158,

I wanted to see if you got the help you needed.

If so, please mark the appropriate reply as the Accepted Solution. It will help other members who may have the same question.
Of course, if you have more to share on your issue, please pursue the conversation. 

Thanks,
Anurag