Problem with Gray Scale Plaette

Hi,

I'm attempting to constrct a bar chart with the Gray Scale Plaette. All the other plaette works fine. However, for the gray scale one, the patterns just go random. It doesn't follow the legend. Have I done something wrong here?

If there is no way to get around this, can I construct one manually? Just wonder how can I do that, cos I want to get some report printed out.

Thanks,

Josh

I am also finding this problem. Can someone from MS let us know if this is a bug? And is there a solution for it coming? or a workaround?|||I also have the same problem. Did anyone find a solution to this?|||

I'm not sure what you mean by "the patterns are random".

Each entry in your legend (ie. data series) should be assigned a different hatch pattern. The point behind the grayscale palette is to make printed black and white output look readable.

It is possible to assign a custom color to your data elements. You do this in the data value dialog - you will need to provide an expression for the color value though to make this work for each unique data values.

|||

The problem is say I have a graph with a default palette. I view the graph, and I have three different colors - one for series 1, one for series 2, one for series 3. The legend has three items, with three different colors, one for each series.

Then I change the graph to grayscale without changing anything else. Now instead of getting three different grayscale patterns, one to represent each color/series, I get a different pattern for every single bar. The legend still shows three items as expected, and just picks the first three patterns to display.

|||This is an issue with 2005 and not 2000 as we didn't see it until converting reports to 2005.|||Actually i have the same problem on SQL2005.
Problem appears when you have more than one group in the chart. Then patterns are applied randomly across the series and groups. Same series in different groups have different patterns, while they should have the same. The legend shows correct patterns for the first group, but it isn't valid for the other groups.
Does anyone know the solution?
My SSRS version is 9.00.2221.00. Do i need some later hotfixes?sql