I have a report that is grouped by location, so I have created a 'Locations' group header and footer. The header contains some titles, and a couple of graphs and the footer contains a row of totals - pretty standard stuff.
The header page containing the graphs have a TextBox with the content =Fields.Location, so for each location, this title represents the location and this works as expected.
The graph on the header page has multiple series (for all locations) and I have applied a filter so the chart data to show only the series for that location: The filter contains the expression: "= Fields.Location = =ReportItem.DataObject.Location". and this works as expected, great.
The problem I have is with the graph title. I need the chart title to show the name of the location, so in the Graph Title Text I've put "=Fields.Location" - however - this only picks up the first location, and then uses that throughout each location???
How can I get the graph titles to reflect the location properly?
1 Answer, 1 is accepted
Please check the settings of the attached demo report in the Standalone Report Designer of R1 2017. the graph item's data is filtered on data retrieval and the graph.Title is Fields.GroupName that is displayed correctly per Graph. The report uses AdventureWorks database.
I hope this helps.
Regards,
Stef
Telerik by Progress