MRP Results

Hi All,

I've managed to come out with the MPR results using Crystal Report 2010 using crosstab.

My question is,

How can i get the date and workweek as shown in B1 MRP results?

Refer to screenshot below.

The columns is basically MSN2.PeriodID

But if i were to output it directly from B1 using the MRP.

I will get output like this.

How can i get that kind of value to show in Crystal report?

Which table should i get it from?

What condition should i use?

Thank you very much for your help.