Jump to content

BIRT Developer Center Download


Photo
- - - - -

PM Forecast Report

maximo

  • Please log in to reply
9 replies to this topic

#1 DavidRiep

DavidRiep

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 03 March 2014 - 09:38 PM

[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

 

 

 

 

 



#2 wwilliams

wwilliams

    Junior Member

  • Members
  • 316 posts

Posted 09 April 2014 - 09:12 AM

If you are still stuck feel free to attach report.



#3 DavidRiep

DavidRiep

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 05 July 2014 - 05:04 PM

Hi All, I've fixed the issue and have created the report that looks like (follow the link) https://drive.google...dit?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



#4 scot

scot

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 12 December 2014 - 02:56 AM

Hi All, I've fixed the issue and have created the report that looks like (follow the link) https://drive.google...dit?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



#5 nmerrill

nmerrill

    Member

  • Members
  • PipPip
  • 16 posts

Posted 15 January 2015 - 03:00 PM

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



#6 haclausen

haclausen

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 27 May 2015 - 08:46 AM

Hi David

 

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

 

Thanks

 

Alfred



#7 martinjw

martinjw

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 06 November 2015 - 10:44 PM

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


#8 cdan

cdan

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 23 November 2015 - 05:49 PM

Hi David,

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

Thank you,
Cristina

#9 Jheronymus

Jheronymus

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 01 December 2015 - 03:25 AM

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



#10 new2birtdev

new2birtdev

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 01 March 2017 - 09:32 AM

Hi David,

 

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

 

Thanks







Also tagged with one or more of these keywords: maximo