BIRT data set prints same data for every itme

I have a BIRT report for Maximo with two scripted data sets. The main data set for purchase requests and the sub data set for purchase request lines. The problem is that the sub data set works fine for a single purchase request and prints the correct data for any give PR, but if you run the report for multiple PR's, the pr lines for the first PR are printed out for every PR.
So what I am getting is something like this.
PR 10
Line 1
Line 2
PR 20
Line 1
Line 2
When PR 20 should have 10 lines, it only gives me two and those two are the same lines as PR 10. I've set the report to print out the SQL that is being created by the data set by populating a global variable called mySQL and printing that on the report. The SQL looks fine and I can cut and paste it into my SQL editor and get the correct results, but that is not what is printing out on the report. I've checked table bindings, I've tried to null out the data set in the script and force it to repopulate but that has no effect. I've created a new data set, but the new data set does the same thing.
Has anyone run into this before? Any ideas at all on what to check? Or how do I go about clearing out the dataset for each PR so that the PRLINE dataset will be clean for each PR?
This is the open script for the dataset.
lineDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName()); 
lineDataSet.open(); 
var sqlText = new String(); 
// Add query to sqlText variable. 
sqlText = "select orderqty, orderunit, itemnum, description, unitcost, linecost, prnum, prlinenum, refwo, assetnum, location, project,tasknum, siteid from maximo.prline_vw " 
+ " where prnum = '" + rows[0]["prnum"].replace(/'/g,"''") + "'" 
+ " and siteid = '" + rows[0]["siteid"] + "'" 
//+ " where prnum = '" + row._outer["prnum"] + "'" 
//+ " and siteid = '" + row._outer["siteid"] + "'" 
// Include the Maximo where clause 
//+ " and " + params["where"] 
; 
lineDataSet.setQuery(sqlText); 
mySQL = sqlText;
And this is the fetch script.
if (!lineDataSet.fetch()) 
return (false); 
// Add a line for each output column 
// The specific get method should match the data type of the output column. 
row["prlinenum"] = lineDataSet.getString("prlinenum"); 
row["orderqty"] = lineDataSet.getFloat("orderqty"); 
row["orderunit"] = lineDataSet.getString("orderunit"); 
row["unitcost"] = lineDataSet.getFloat("unitcost"); 
row["linecost"] = lineDataSet.getFloat("linecost"); 
row["prnum"] = lineDataSet.getString("prnum"); 
row["itemnum"] = lineDataSet.getString("itemnum"); 
row["refwo"] = lineDataSet.getString("refwo"); 
row["siteid"] = lineDataSet.getString("siteid"); 
row["description"] = lineDataSet.getString("description"); 
row["project"] = lineDataSet.getString("project"); 
row["tasknum"] = lineDataSet.getString("tasknum"); 
row["assetnum"] = lineDataSet.getString("assetnum"); 
row["location"] = lineDataSet.getString("location"); 
return (true);

Find more posts tagged with

Comments

Virgil Dodson

moving topic to using BIRT with Maximo forum

vijj

Are you using second internal table inside detail section of main one with binding to sub-dataset? Can you post the report here?