I work on FOCUS 7.1.1. I need to create a report which should have data in columns (ideally it should be in rows, but due to user requirement I need to prepare report which would have columns).
The scenario is as belows -
A part can belong to 'n' number of models. Below is how the report ideally should look -
Part Model
---- ------
P1 M1
P1 M2
P1 M3

P2 M1
P2 M2

P3 M2

P4 M1
P4 M2
P4 M3
P4 M4

The user wants to create report with each model in column. The report is needed as belows -

PART M1 M2 M3 M4
---- -- -- -- --

P1 y y y
P2 y y
P3 y
P4 y y y y

As you can see the problem is there are no fixed values or count of model to which the part can belong. The count of Ms (models) can go anywhere from 10 to 125. So I don't know how many columns to define for this report.
One option is to use ACROSS command as below -

TABLE FILE HOLDPART
PRINT
INDICATOR
BY PART_NUM
ACROSS MODEL_CD
ON TABLE HOLD AS HOLD1
END

But this creates another issue - "I cannot join the Part number from this file to my main file".
Because once I give ACROSS MODEL_CD command FOCUS splits one column of MODEL_CD into multiple columns like M1, M2, M3.... and MODEL_CD is lost. MODEL_CD does not belong to HOLD1 file. M1, M2, M3 ....belong to HOLD1.

How do I use this HOLD1 file to join it back to main report? Or is there any other way to achieve this?

I know my question may sound a big one but any help is welcome.

Thanks,
Gaurav.