Skip to main content

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 17:17
Gopi  is currently offline Gopi Friend
Messages: 10
Registered: May 2011
Junior Member

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: Thu Jun 21 20:25:53 GMT 2018

Powered by FUDForum. Page generated in 0.01488 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top