Skip to main content
A
Anonymous
September 30, 2010
Question

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

  • September 30, 2010
  • 2 replies
  • 866 views

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

This topic has been closed for replies.

2 replies

R
ralf_g
Participating Frequently
December 8, 2010

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

R
ralf_g
Participating Frequently
December 8, 2010

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

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices