This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hi,
We are using BIRT 3.7.1, Maximo 7.5 with Oracle and have noticed that the out of the box Work Order Hierarchy report is only displaying the first child under the parent.
For example, for the following hierarchy where WO1000 is the parent and WO1001 to WO1003 are the children
WO1000
WO1001
WO1002
WO1003
When we run the report it only displays
WO1000
WO1001
Do others have the same problem? Note that the report displays all four work orders when I run it within BIRT designer!
Thanks
Tim
1. Only This WO Number or at all WO are the children
2. You must try run script in BIRT to SQL Plus, if many script you try
step by step for result display.
Salam,
Mawardi
"fowlowt" <fowlowt@yahoo.com>
Sent by: MAXIMO@yahoogroups.com
02-09-2012 04:51
Please respond to
MAXIMO@yahoogroups.com
To
MAXIMO@yahoogroups.com
cc
Subject
[MAXIMO List] Work Order Hierarchy report only displaying the first child
Hi,
We are using BIRT 3.7.1, Maximo 7.5 with Oracle and have noticed that the
out of the box Work Order Hierarchy report is only displaying the first
child under the parent.
For example, for the following hierarchy where WO1000 is the parent and
WO1001 to WO1003 are the children
WO1000
WO1001
WO1002
WO1003
When we run the report it only displays
WO1000
WO1001
Do others have the same problem? Note that the report displays all four
work orders when I run it within BIRT designer!
Thanks
Tim
Hi Tim,
Perhaps, the error occurs because of the compatibility issue between maximo 7.5 and Birt 3.7.1.
Previously, we upgrade our BIRT designer from 2.3.2 to BIRT 3.7.1 (The latest).
After the upgrade, we notice that maximo 7.5 cannot read many rptdesign files we designed in BIRT 3.7.1. In several case, maximo 7.5 cannot import the rptdesign files.
When we reverted back to BIRT 2.3.2, the problem disappear.
The other possibility is the dataset is placed not in the report detail section. Perhaps, it's in the report header or the footer.
Hope this helps.
Regards,
Tommy.
-----Original Message-----
From: "fowlowt" <fowlowt@yahoo.com>
Sender: MAXIMO@yahoogroups.com
Date: Sat, 01 Sep 2012 21:51:22
To: <MAXIMO@yahoogroups.com>
Reply-To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Work Order Hierarchy report only displaying the first child
Hi,
We are using BIRT 3.7.1, Maximo 7.5 with Oracle and have noticed that the out of the box Work Order Hierarchy report is only displaying the first child under the parent.
For example, for the following hierarchy where WO1000 is the parent and WO1001 to WO1003 are the children
WO1000
WO1001
WO1002
WO1003
When we run the report it only displays
WO1000
WO1001
Do others have the same problem? Note that the report displays all four work orders when I run it within BIRT designer!
Thanks
Tim
Tim,
Any update on this one?
The report must display all WO in the hierarchy, so having only the first
children displayed is a not a standard behaviour.
On Mon, Sep 3, 2012 at 7:44 AM, <hediaka@yahoo.co.id> wrote:
> **
>
>
> Hi Tim,
>
> Perhaps, the error occurs because of the compatibility issue between
> maximo 7.5 and Birt 3.7.1.
> Previously, we upgrade our BIRT designer from 2.3.2 to BIRT 3.7.1 (The
> latest).
>
> After the upgrade, we notice that maximo 7.5 cannot read many rptdesign
> files we designed in BIRT 3.7.1. In several case, maximo 7.5 cannot import
> the rptdesign files.
> When we reverted back to BIRT 2.3.2, the problem disappear.
>
> The other possibility is the dataset is placed not in the report detail
> section. Perhaps, it's in the report header or the footer.
>
> Hope this helps.
>
>
>
>
> Regards,
>
> Tommy.
>
> -----Original Message-----
> From: "fowlowt" <fowlowt@yahoo.com>
> Sender: MAXIMO@yahoogroups.com
> Date: Sat, 01 Sep 2012 21:51:22
> To: <MAXIMO@yahoogroups.com>
> Reply-To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] Work Order Hierarchy report only displaying the
> first child
>
> Hi,
> We are using BIRT 3.7.1, Maximo 7.5 with Oracle and have noticed that the
> out of the box Work Order Hierarchy report is only displaying the first
> child under the parent.
>
> For example, for the following hierarchy where WO1000 is the parent and
> WO1001 to WO1003 are the children
>
> WO1000
> WO1001
> WO1002
> WO1003
>
> When we run the report it only displays
> WO1000
> WO1001
>
> Do others have the same problem? Note that the report displays all four
> work orders when I run it within BIRT designer!
>
> Thanks
>
> Tim
>
>
>
>
>
>
>
>
--
Mohamed Skandaji, MBA, PMP
I ended up recoding the BIRT report to use a different sub query for each level in the hierarchy instead of reusing the same sub query as per the out of the box code.
This resolved the issue.
Tim
--- In MAXIMO@yahoogroups.com, Mohamed Skandaji <mohska@...> wrote:
>
> Tim,
> Any update on this one?
>
> The report must display all WO in the hierarchy, so having only the first
> children displayed is a not a standard behaviour.
>
>
>
>
>
> On Mon, Sep 3, 2012 at 7:44 AM, <hediaka@...> wrote:
>
> > **
> >
> >
> > Hi Tim,
> >
> > Perhaps, the error occurs because of the compatibility issue between
> > maximo 7.5 and Birt 3.7.1.
> > Previously, we upgrade our BIRT designer from 2.3.2 to BIRT 3.7.1 (The
> > latest).
> >
> > After the upgrade, we notice that maximo 7.5 cannot read many rptdesign
> > files we designed in BIRT 3.7.1. In several case, maximo 7.5 cannot import
> > the rptdesign files.
> > When we reverted back to BIRT 2.3.2, the problem disappear.
> >
> > The other possibility is the dataset is placed not in the report detail
> > section. Perhaps, it's in the report header or the footer.
> >
> > Hope this helps.
> >
> >
> >
> >
> > Regards,
> >
> > Tommy.
> >
> > -----Original Message-----
> > From: "fowlowt" <fowlowt@...>
> > Sender: MAXIMO@yahoogroups.com
> > Date: Sat, 01 Sep 2012 21:51:22
> > To: <MAXIMO@yahoogroups.com>
> > Reply-To: MAXIMO@yahoogroups.com
> > Subject: [MAXIMO List] Work Order Hierarchy report only displaying the
> > first child
> >
> > Hi,
> > We are using BIRT 3.7.1, Maximo 7.5 with Oracle and have noticed that the
> > out of the box Work Order Hierarchy report is only displaying the first
> > child under the parent.
> >
> > For example, for the following hierarchy where WO1000 is the parent and
> > WO1001 to WO1003 are the children
> >
> > WO1000
> > WO1001
> > WO1002
> > WO1003
> >
> > When we run the report it only displays
> > WO1000
> > WO1001
> >
> > Do others have the same problem? Note that the report displays all four
> > work orders when I run it within BIRT designer!
> >
> > Thanks
> >
> > Tim
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
> --
> Mohamed Skandaji, MBA, PMP
>
>
>
>