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.
Correct.. Non persistent field will not work with a QBR.. Also you cannot group like Shannon is needing to do.. So jason answer was her only options..
Shannon Sutton
Cell: 571-970-7965
On May 24, 2012, at 6:34 PM, mohska@gmail.com wrote:
> I dont think you can use non persistent fields for QBR
> Everything Will Work fine until you use the OBject structure in the QBR (from What i remember in 7.1)
>
> Sent from my iPhone
>
> On 24 May 2012, at 22:59, Gideon Olivar <g_olivar2002@yahoo.com> wrote:
>
> > Hi Shannon,
> >
> > You are using 7.5 right? You can create an object structure with Inventory tables with the relationships. You can select persistent and non-persistent columns with it. Then define that the object structure you have created will be used by reporting. Once you have this setup, then you can use QBR for it. I am happy to provide you the details if what I am saying makes sense to you.
> >
> > Regards
> >
> > ________________________________
> > From: shannonrotz <shannonrotz@yahoo.ca>
> > To: MAXIMO@yahoogroups.com
> > Sent: Friday, 25 May 2012 1:06 AM
> > Subject: [MAXIMO List] Re: V7.5 - Ad-Hoc Reporting Functionality
> >
> >
> >
> > Right - thanks Jason. I thought it might be something like that!
> >
> > Shannon
> >
> > --- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@...> wrote:
> > >
> > > Wes is right, because the total curbal is a calculated/non-persistent data value you can't do it out of the box with a QBR report. The two choices left are:
> > >
> > > 1. Try to create a view like Wes suggested and then add that view as part of the report object structure. This a route I'm working on to mimic labor/person availability in Assignment manager.
> > >
> > > 2. Create the core report via QBR tool and then tweak it in BIRT designer.
> > >
> > >
> > >
> > > --- In MAXIMO@yahoogroups.com, "shannonrotz" <shannonrotz@> wrote:
> > > >
> > > > Yep!
> > > >
> > > >
> > > > Shannon
> > > >
> > > > --- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@> wrote:
> > > > >
> > > > > So if the item is stored in 3 bin locations, and each bin has 2 items, you want the report to show a single row for the itemnum and a cur bal of 6. Is that correct?
> > > > >
> > > > > --- In MAXIMO@yahoogroups.com, "shannonrotz" <shannonrotz@> wrote:
> > > > > >
> > > > > > Hi guys:
> > > > > >
> > > > > > Anyone know if you can add totals to a report that you're creating through the Ad-Hoc Reporting tool?
> > > > > >
> > > > > > I'm trying to create an Inventory report that shows the total balance for each item, but off-hand I can't see a way to do that.
> > > > > >
> > > > > > Jason: I bet you know this one ...
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > Shannon
> > > > > >
> > > > >
> > > >
> > >
> >
> >
> >
> >
>
>
>
>
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No confidentiality or privilege
is waived or lost by any mistransmission. If you receive this message in error,
please immediately delete it and all copies of it from your system, destroy any
hard copies of it and notify the sender. You must not, directly or indirectly,
use, disclose, distribute, print, or copy any part of this message if you are
not the intended recipient.