pass variable into ValueColumn of SPC Chart

[Former Member]

I need to pass the ValueColumn field into the chart. How do I do this. I think I have it set up properly, but I can not get data unless I manually set it up in the display template, which I do not want to do. What do I need to do to make this work? The Title works fine.

<tr>

<td>

<applet name='Chart1' codebase='/Illuminator/Classes' code='iSPCChart' archive='illum8.zip' width='775' height='350' mayscript>

<param name='DisplayTemplate' value='../FR/dspFR_ATD_Production_SPC'>

<param name='QueryTemplate' value='../FR/qryFR_ATD_Production_SPC'>

<param name='ValueColumns' value='Pitch'>

<param name='Title' value='Pitch Data'>

<param name='Param.1' value='%'>

<param name='Param.2' value='%'>

<param name='Param.3' value='%'>

<param name='Param.4' value='%'>

</applet>

</td>

</tr>

[jcgood25]

You have the parameter name and assignment correct so that's not the problem. Try right-clicking on the applet and selecting raw data details, then observe the column heading names in your query results - do you see one called 'Pitch' and is it numeric?

Relative template paths don't work, so unless the "../" is there to hide something I would imagine your query is throwing a FatalError and producing the 'No Data Points' message.

The title is merely text so that will appear even if the query fails or there are other issues.

Regards,

Jeremy