PM Forecast Report

[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

Find more posts tagged with

Comments

wwilliams

If you are still stuck feel free to attach report.

PM.rptdesign

DavidRiep

Hi All,

I've fixed the issue and have created the report that looks like (follow the link)
<a data-ipb='nomediaparse' href='http://www.linkedin.com/redirect?url=https://drive.google.com/file/d/0B_MIIGlMK-PFZllmVW5LXzdMTTA/edit?usp=sharing&urlhash=nkFk&_t=tracking_disc'>https://drive.google.com/file/d/0B_MIIGlMK-PFZllmVW5LXzdMTTA/edit?usp=sharing</a>

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

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

Thanks

Regards,

David

PM.rptdesign

scot

<blockquote class="ipsBlockquote" data-author="DavidRiep" data-cid="129174" data-time="1404608699">
<div>
Hi All, I've fixed the issue and have created the report that looks like (follow the link) <a data-ipb='nomediaparse' href='http://www.linkedin.com/redirect?url=https://drive.google.com/file/d/0B_MIIGlMK-PFZllmVW5LXzdMTTA/edit?usp=sharing&urlhash=nkFk&_t=tracking_disc'>https://drive.google.com/file/d/0B_MIIGlMK-PFZllmVW5LXzdMTTA/edit?usp=sharing</a> It's Grouped by PM number and then Asset number. If anyone is interested in the report, please let me know. Thanks Regards, David
</div>
</blockquote>
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

PM.rptdesign

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

PM.rptdesign

haclausen

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

PM.rptdesign

martinjw

<div>Hi David,</div>
<div>I'm interested in your report. if you don't mind I would like a copy too.</div>
<div>Thanks,</div>
<div>Martin</div>

PM.rptdesign

cdan

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

PM.rptdesign

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

PM.rptdesign

new2birtdev

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

PM.rptdesign

Karthikeyan

Hi David,
 
Can you please share the Report design.
 
Thanks & Regards

PM.rptdesign

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

PM.rptdesign

Neel1403

Hi David ,

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

Thanks,
Neel

PM.rptdesign

imaginelife17

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

PM.rptdesign

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.

PM.rptdesign