I have several charts inside a template. The properties of those charts’ data sources are SQL queries that use a Template parameter as part of the query. When I add an instance of the template to a window, it will temporarily flicker the data in the chart to whatever parameter I used in the actual template designer, ignoring the value given to the instance on the main window. This behavior stops if I turn the polling off but then I wouldn’t see the charts update.
The following screenshots hopefully illustrate this a little better. The following query should use whatever value I give the instance for BU_ID. But the data will temporarily change to BU_ID = 1 because that is the value in the template designer.
I’m sure I missed a setting somewhere. Thanks in advance as this has been driving me crazy!