Having a chart change based on what group is displaying in Report Builder.

[Guest]

Hello, I'm trying to create a report that is grouped by department that shows data for the last 12 months in the detailed section. I also want to have a chart that will graph that data in the group header. I have tried to 'link' the query in the chart using #query.dept_id# to limit the data to just that department, but the #query.dept_id# does NOT seem to change when the dept_id changes. There seems to be a way to link a sub-report, but no way to link a chart.

Any help would be greatly appreciated.

Thanks

[ralf_g]

We had the same problem: The chart data does not change when the group content changes.

Workaround:

define a sub report with the chart in,

use an input parameter to pass the current group key to the sub report.

Did not find another way to do so.

Best regards

[ralf_g]

Found a better solution to solve this, subreport is not needed:

1. define a calculated field for the value that changes with the group.
   it is not necessary to place this anywhere in the report, just define it.
   
   
2. use this calculated field in the chart query instead of the report query field.

Best regards