Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Passing oracel funtions to BIRT report
Passing oracel funtions to BIRT report [message #686096] Tue, 21 June 2011 13:17
Gopi  is currently offline Gopi
Messages: 10
Registered: May 2011
Junior Member
Hi,

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
Previous Topic:td.valign=top everytime. Howto set to bottom?
Next Topic:Can the output PDF Version be controlled by BIRT?
Goto Forum:
  


Current Time: Wed Jul 30 13:25:26 EDT 2014

Powered by FUDForum. Page generated in 0.02434 seconds