How to update workorder_hierarchy.rptdesign

Hi all --
looking for help to update the workorder hierarchy report that ships with Maximo 7.

Adding 3 new workorder fields to the maindataset is successful.
Adding those same 3 fields to the subdataset causes it to fail.

I see two prompts in the report design that I don't know what to do with. Am I making the wrong choice on either or both of these?

-- Output Columns tells me there is a null parameter. This is the same OOB so I tell it to ignore.
-- Refreshing table bindings prompts me to generate bindings for output paramaters. I tell it NO because I don't see them in the original data binding.

Maximo error starts off like this:

org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "if (!subDataSet.fetch())
return (false);

Find more posts tagged with

Comments

jverly01

Can you upload your report so we can see how the fields have been added?

SharonJ

Thank you for your reply!

When I try to attach the report design file I get an upload error.

Does this help at all?
======================================

subDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
subDataSet.open();

var sqlText = new String();

// Add query to sqlText variable.
sqlText = "select woancestor.wonum, workorder.description, workorder.workorderid, "
+ " workorder.targcompdate, workorder.schedfinish, workorder.schedstart "
+ "from workorder, woancestor "
+ "where workorder.wonum = woancestor.wonum "
+ "and woancestor.hierarchylevels = 1 "
+ "and woancestor.ancestor = ? "
+ "order by woancestor.wonum asc"
;

subDataSet.setQuery(sqlText);
subDataSet.setQueryParameterValue(1, inputParams["wonum"]);