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 Gang,
In Maximo 6, has anyone been able to pass the current user to an Actuate Report? We want to be able to have a user run a report that will display their current labor transactions. Has anyone done this in Maximo 6?
thanks,
John
John,
We have some examples of Actuate Reports where we did this in Maximo 6, if you would like me to send you a copy of these reports. Please provide a direct email address and I will send one as an attachment.
Please respond directly to my work email provided below, not my Yahoo email.
Regards,
Patrick Burrows
patrick.burrows@talecris.com
--- In MAXIMO@yahoogroups.com, John Ballnik <jballnik@...> wrote:
>
> Hi Gang,
>
> In Maximo 6, has anyone been able to pass the current user to an Actuate Report? We want to be able to have a user run a report that will display their current labor transactions. Has anyone done this in Maximo 6?
>
> thanks,
> John
>
>
>
>
--- In MAXIMO@yahoogroups.com, John Ballnik <jballnik@...> wrote:
>
> Hi Gang,
>
> In Maximo 6, has anyone been able to pass the current user to an Actuate Report?� We want to be able to have a user run a report that will display their current labor transactions.� Has anyone done this in Maximo 6?
>
> thanks,
> John
>
>
>
>
This was written to print out a report of labor assignments for the next week for the user running the report. Designed to be schedulable with the start and end dates dynamically determined based on date run.
select distinct
:CurrentUser
,:laborcd
, c.status
,c.description
,c.wonum
,c.taskid
,c.wogroup
,c.laborcode as labindiv
,c.craft,c.crewid
,wo.calcpriority
,wo.worktype
, wo.location
,b.laborcode
,b.craft
,b.crewid
,b.wolhrs
,case when c.laborcode = b.laborcode
then null
else b.craft end as othercraft
,case when c.laborcode != b.laborcode
then b.laborcode
else null end as otherlabor,
next_day(to_date(trunc(sysdate-4)), 'SATURDAY') as Week_Start,
next_day(to_date(trunc(sysdate +2)),'FRIDAY') as Week_End,
to_char(to_number (to_number (NEXT_DAY (TO_DATE (TRUNC( sysdate - 4)), 'SATURDAY')-to_date('23-jan-2010'))/7)) as wknum
from cmms_schddata c left outer join workorder wo on wo.wonum = c.wonum
join
(
select wonum,laborcode,craft,crewid,wk,
Case when :laborcd != 'You'
then :laborcd
else :currentuser
end as labr,