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.
Time machine thank you. I needed this help last week, found it on my list, and it worked. Awesome.
-C
---In MAXIMO@yahoogroups.com, <craig.behan@emcoruk.com> wrote :
Hello,
First you need to create 2 global variables (startdate & enddate) in
the ErdPro Designer in Tools/Parameters - make sure the required box
is checked and the type is date. Then in your query you will need
something like this:
'and workorder.targstartdate >= :startdate and
workorder.targstartdate <= :enddate'
Finally when you have published the report to the Encyclopedia and
registered the report in Maximo. In Report Administration for each
parameter your report contains you will need to add a new row to the
Reports Lookup section. For example the startdate parameter requires
the following values:-
Parameter name: startdate
Attribute Name: targstartdate
Lookup name: datelookup
Operator: >=
Display Sequence: 1
Overide Label: Start Date:
Required: check the box
Regards,
Craig
--- In MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com, "Tommy Hediaka" <hediaka@...> wrote:
>
> Hello,
> how to create a report with "start date" paramater and "end date"
parameter?
> I looked at maximo custom report with similiar to my report, it is
inventory_transaction_act and e_sig_trans_act. Unfortunately, my
report is still error.
> please tell me some steps in order to build report by using
startdate parameter and enddate parameter? we're using maximo62 and
actuate8.
> I gladly appreciate it. Thank you in advance. Help...
>