12-Amethyst

Solved

Query Builder Report - Parts linked to Resource

Hi,

I try to have a Report with latest version of WTpart related to a list of Resouce ( Workcenter,Tooling..).

There is someone able to help me please?

Best regards

Gianpaolo

Best answer by Marco Tosin

I have a report that links materials, equipment, cycles, operations, and work centers.

The name of the table labels are in Italian but it should not be difficult to retrieve the internal name from query builder.

The definitions table is used, trough criteria, to perform a join (my consultant's suggestion)

21-Topaz I

Ciao Gianpaolo,
retrieving the latest version in the query builder reports is not exactly easy.

Below you can find some examples of ready-made reports containing the filter on the latest version for various types of objects

Marco

21-Topaz I

In case you also have multiple views of the same object (Design, Manufacturing, Plant) it is even more complicated.

Here is a link to a discussion on the subject.

Marco

Author

12-Amethyst

Hi Marco,

fetching the latest version is ok.

My scenario has 4 different Manufacturing Plants.

I need to build a report with connection between Resources and WTPart

Gianpaolo

21-Topaz I

Try these

Marco

Sign up