Can someone please provide some insight about how embedded code works in terms of scope? I am trying to show moving average values on charts using the custom code from http://msdn.microsoft.com/en-us/library/aa964128%28SQL.90%29.aspx. My chart
has an actual series group, which has multiple values. To be specific, my data series is profit per unit; my series group is division; and I have time on the X axis. The "division" series group can have multiple values such as "US",
"Europe", and "Asia". Looking at the moving average custom code from the above link, I really wonder how the global variables, such as "queue" and "queueSum", are handled across the multiple series group values.
Can it correctly separate the queue for division "US" from the queue for division "Europe" and "Asia"?
Also, I have multiple charts ont he same report and they all use the moving average custom code. Does SSRS use different instances of the global variables so that one chart is calculated separately from another?
View Complete Post