Applying different patterns to series groups in chart, does not display properly in legend.
I've been working on a chart which has multiple series. To make it easier to read when printed B/W, I've been working to apply a different pattern to each series. I found an article that outlined a way to do this, and it mostly worked. http://ch1n2.wordpress.com/2011/03/21/how-to-assign-a-different-color-on-each-category-group-in-the-bar-chart-on-ssrs-2008r2-if-you-dont-have-any-series/ The issue is that while the Bars in the chart for each series render the pattern I've assigned, the legend does not always render the pattern for each series, however, the colors do match. This is a stacked bar chart, and I've also noticed that the only series in the legend that render the pattern are those that occur in the first category grouping displayed on the chart. For example, this chart is to show help desk ticket trending, category group by week, series grouped by call type. In a month, there were calls for Software, Printing, and Phone issues. The first week of that month only had calls for Printing issues. Only printing will render the pattern I've assigned in the chart and legend; the other call types will render the pattern in the chart, but have only solid color in the legend. If I adjust the filter so that I have a period where all 3 of the call types occurred in the first grouped week, then the pattern renders for all of them in the chart and legend properly. See images below: - Jon
June 20th, 2012 3:02pm

Hello Jon, From your description, the issue is that the legend does not show correctly as you set in the report. Based on my experience, it is a known issue of Reporting service. If the item does not appear in the first column, the legend will not be rendered as a default color. You can try the following workaround to see whether it can solve this kind of issue. Change the value field for the Series from Count(Fields!XXXX.Value) to IIF(IsNothing(Fields!XXX.Value), Nothing, Count(Fields!XXXX.Value)).Set Fill for the series to Automatic instead of an expression. I hope my workaround is helpful to you. If you have any questions, please tell us freely. Regards, EdwardEdward Zhu TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
June 22nd, 2012 5:39am

Edward, Thanks for your response. Number 1 you suggested fixed my issue.- Jon
June 22nd, 2012 9:54am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics