Hi,

I am migrating a report from crystal. Can anyone give me a hint how can I reach those ranked columns.

First rank column is based on last full month. ( last month)
Second rank column is based on month to date. ( current month)

thanks

This message has been edited. Last edited by: Ricardo Augusto,

Not 100% sure I understand but if per chance I do

TABLE FILE WHATEVER
RANKED BY HIGHEST THIS_MONTH
WRITE WHATEVER
ON TABLE HOLD AS 'J1'
END

TABLE FILE WHATEVER
RANKED BY HIGHEST LAST_MONTH
WRITE WHATEVER
ON TABLE FILE HOLD AS 'J2'
END

TABLE FILE J1
PRINT *
ON TABLE HOLD
MORE
FILE J2
END

Well, no. MORE just adds rows, Here we need to add two new columns.

Match file can be used for that purpose

So can JOIN (create a Focus hold file, index the key; repeat for the other rank; join the original to both.)

Thanks Hinds and j.gross