Chart Legend Edits not holding - CR XI R2
We are making a report with multiple sub reports. Many of the sub reports are charts (Pie, stacked bar & line). The default legend labels are "Sum of [table or query name].[field name]." When we preview, then edit the legend labels to something more user friendly and save, the edits don't stick. As long as the report is open it looks OK, as soon as the report is closed and reopened it reverts back to the default legend label.
What can be done to correct this behavior so the legend labels once edited will hold the value assigned?
The main report is simply a shell to hold the sub reports with conditionals for each section/sub report to allow for that sub report to be shown or not. There are no links between the sub reports or the sub reports and the main report. There are approximately 100 sub reports and about 1/3 of them are charts.
As a matter of fact I did resolve the problem of getting the legend label changes to stick. It is a multi-step process and not at all intuitive.
First preview the report and select the label you want to change, right-click and select the Edit Axis Label from the pop-up menu then edit the Displayed Label field with what you want to display. Do this for all the lables you want to change.
Then while still in preview right-click on the chart area (not the legend), you should see a long pop-up menu, in the middle of this pop-up is the Apply Changes to All Charts, click this (This is the 'Secret Sause" to making your change stick); and then Save the (sub)report.
Repeat these steps for each sub report and when finished Save the Main report. Your chart labels should now be what you edited them to.
Edited by: Steve S on Nov 11, 2008 5:59 AM