Assign Ad Hoc Measure to a Specific Y-axis In Ad Hoc Reports

Use Case

Customer created an Ad Hoc Report with dual-axis chart.

He would like to assign the second Ad Hoc Measure to the first Y-axis, instead of the second, by default, one.

Resolution

In TIBCO JasperReports® Server v.7.1.0 and newer version, you can set chart properties with array indices in JRXML.

So if the related Ad Hoc View only has measures on the columns axis, you can directly set the yAxis properties of a series like this:

<jrhc:chartSetting name="_jrs_adhoc">......</jrhc:chartSetting><jrhc:chartSetting name="default"><jrhc:chartProperty name="series[1].yAxis"><jrhc:propertyExpression><![CDATA[0]]></jrhc:propertyExpression></jrhc:chartProperty></jrhc:chartSetting>[/code]

This puts the second measure/series (series[1]) on the first axis (0).

The solution will not work with version of  TIBCO JasperReports® Server less than 7.1.0 as property name "series[1].yAxis" will not be recoginzed

AS-20190403, case #01713498