[font="arial, helvetica, sans-serif;"]Dear All, [/font]
[font="arial, helvetica, sans-serif;"]I've got a PM forecast report which I would like to display like the following below. But instead of X, I would like to show the interval i.e X is replaced with M for monthly.[/font]
I was hoping someone could help with a report I'm trying to create.
PM Decscription Location JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
PMXXXXXX DESCXXXXXXXXXXXXXXXXX(Q) BLD349 X - - X - - X - - X - -
PMXXXXXX DESCXXXXXXXXXXXXX(1M, 12M BLD349 X X X X X X X X X X X X
I've grouped the table by YEAR then PMNUM and have placed the information in the PMNUM group header.
I've then created aggregations filtered by date, grouped by PMNUM.
If there is a value above 0, on the render, I've scripted it so it shows an X. Vice versa, if the value is 0 then I display an -. The trick I am stuck with is the group header will always display the first record even if I filter the aggregation. I would love to know how to choose the record to show the interval.
If anyone could please point me in the right direction, that would be much appreciated.
I can also attach the report if required.