|Passing oracel funtions to BIRT report [message #686096]
||Tue, 21 June 2011 13:17
Registered: May 2011
Please suggest If I can use oracle funtions to BIRT report.
Here is my sql adn i am using wocostroolup funtion that is created in oracle.
Report is not erroring out.It is just keeep running and is not sowing output.
select asset.assetnum ,asset.description,asset.location,locations.description as locdesc,workorder.worktype," " (sum(MAXIMO.WOCOSTROLLUP(WORKORDER.SITEID,WORKORDER.WONUM,'ACTLABCOST+ACTMATCOST+ACTTOOLCOST+ACTSERVCOST') )) as costrollup + " from Asset "
+ " left outer join workorder on workorder.assetnum =asset.assetnum and workorder.siteid = asset.siteid "
+ " left outer join locations on locations.location=asset.location and locations.siteid =asset.siteid "
// Include the Maximo where clause
+ " where " + params["where"]
+ " and workorder.istask ='0' and workorder.worktype in ('CM', 'CP', 'EM' ,'EV' ,'FS','S','PM') "
+ " group by asset.assetnum,asset.description,asset.location,locations.description ,workorder.worktype"
Thank you in advance
Powered by FUDForum
. Page generated in 0.14062 seconds