PM Forecast Report

DavidRiep

[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.

 

Thank you

 

Regards,

 

David

 

 

 

 

 

wwilliams

If you are still stuck feel free to attach report.

DavidRiep

Hi All,

I've fixed the issue and have created the report that looks like (follow the link)
https://drive.google.com/file/d/0B_MIIGlMK-PFZllmVW5LXzdMTTA/edit?usp=sharing

It's Grouped by PM number and then Asset number.

If anyone is interested in the report, please let me know.

Thanks

Regards,

David

scot

Hi All, I've fixed the issue and have created the report that looks like (follow the link) https://drive.google.com/file/d/0B_MIIGlMK-PFZllmVW5LXzdMTTA/edit?usp=sharing It's Grouped by PM number and then Asset number. If anyone is interested in the report, please let me know. Thanks Regards, David

Hi David,

 

I'm interested in your report.  I'm a relative novice creating BIRT reports but trying to do the same PM forecast at the moment.

 

Thanks,

Scott

nmerrill

Hi David,

I just came across this post and am very interested in your PM Forecast Report. I was recently asked by management to come up with such a report.

Thanks

Norm

haclausen

Hi David

 

I have the same problem so please if you don't mind I would like a copy too.

 

Thanks

 

Alfred

martinjw

Hi David,

I'm interested in your report.  if you don't mind I would like a copy too.

Thanks,

Martin

cdan

Hi David,


I'm very interested in your PM Forecast Report. Could you send me a copy, please?


Thank you,

Cristina

Jheronymus

Hi,

 

I realy like this report. If any of you has it, please attach it to this thread or send my an PM.

 

Kind,

 

regards,

 

Jeroen

new2birtdev

Hi David,

 

I am interested in this report. If you don't mind please send me a copy.

 

Thanks

Karthikeyan

Hi David,

 

Can you please share the Report design.

 

Thanks & Regards

wwilliams

I have attached a basic PM schedule report. At our Maximo instance we don't use PM's, but I thought I'd try to create something that might lead others to improve. The deeper you get into this the more complicated it becomes. (lots of options)

It is based off the PM.nextdate and this is for Sql Server.

 

Wes

Neel1403

Hi David ,

Can you please share the rptdesign .
I am in dire need of this .

Thanks,
Neel

imaginelife17

Hi All,
If someone has designed PM forecast report , please share the report design file.

wwilliams

I haven't looked at this or gone any further since 2017 as we don't use the PM module. If you choose to use this as a base please share.