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.