run birt report against a work order in maximo 75

We have a report runs well with a parameter wonum. Now user likes to run this report when he find his ideal workorder, and directly run against it, without typing workorder#.
Can anyone help this?
I believe the first step is to remove the parameter from birt designer, but not sure the next.
BTW, birt version is 3.7.
Any help is appreciated!

Find more posts tagged with

Comments

wwilliams

Make sure the + " where " + params["where"] + " is there and in the proper space and register it kind of like wotrack.rptdesign is registered

oraBirt

Thanks very much for your speedy help!
The last line of the query is "where" + params ["where"] now, (was +" and workorder.wonum ='"+params["wonum"] +"'"), but got an error SQL command not properly ended.

wwilliams

Do you have the following in your initialize method or something similar?
mxReportScriptContext.setDefaultLogLevel("DEBUG"); 
mxReportScriptContext.setDefaultLogFile("c:/temp/repairs.log") 
scriptLogger = mxReportScriptContext.getReportScriptLogger();
 
if not add it then run the report and look at the file and our copy and paste to your SQL tool e.g. Toad or MS mgt studio and execute it. it should become clear what issue is.

oraBirt

You are 100% correct!! The problem was a little syntax problem, after it is fixed, I see desired results.
 
Your great help is really appreciated!!