Combining two Query Builder Reports into one.

Forum|Forum|8 years ago
March 7, 2018
2 replies
4801 views

Currently have two separate but very similar Query Builder Reports that I would like to combine into one.

Both reports are for change notices, and we create change notices for both EPM Documents (CAD) as well as WTDocuments (PDF). So we have three scenarios for the change notice :

Only EPMDocs.
Only WTDocs
Both

The two existing reports work fine separately, but when combined deliver incorrect results. I suspect that I don't have the joins done correctly.

Any advice?

1_WindchillReports.zip

Reporting

M

MikeLockwood

22-Sapphire I

Combined report likely working ok for changes that involve both EPM and WT, but not for those with just one type - because it's looking for an AND condition. Need to arrange essentially as an OR condition.

M

mdebower

Author

18-Opal

Makes sense and I suspected as much. How do I tell it to treat it as an OR?

M

MikeLockwood

22-Sapphire I

I can do this using sql but haven't been successful yet in query builder reports. Hopefully someone else can chime in.

M

mdebower

Author

18-Opal

Okay, made some progress, but not completely there yet. Doing the outer joins gets me everything listed, but when I add any Criteria against either the WTDocument or the EPM Document, it falls on it's face.

Added an Outer Join Against: Change Task on the From Tab.

M

mdebower

Author

18-Opal

Made some more progress and am getting very close, I think.

Found that if you use OR statements in the Criteria, you can filter out the extra information for the most part. Will attach the latest QML file for review.

1_CHANGE_CHANGED-DRAWING-REPORT-combined.zip