SSRS Chart pattern insteda of colored bars

Hello
I would like to know how to change the layout properties of a chart, If I have 5 values that are to be represented in a bar chart reporting server colors them, however those reports will be printed in black and white and I would like each bar value to have its unique pattern instead of a different color.
How can I set such a behaviour

Thank
LVL 9
xav056Asked:
Who is Participating?
 
xav056Connect With a Mentor Author Commented:

What is was looking for is achievable by chossing the greyscale pattern from the pallete property Thanks
0
 
Megan BrooksSQL Server ConsultantCommented:
I haven't worked a lot with charts, but if you want each "series" in the bar chart to have its own pattern, that isn't hard to change.
In Report Designer, if you click on the chart so that you see the "Drop data fields here" pane at the top of the chart (it may take a few tries to get there), the series items appear in that pane.
  1. Right click any one of the series items
  2. Select "Series properties"
  3. Select "Fill"
  4. Change the Fill style to Pattern
  5. Change the color and pattern to whatever you would like. You can set the color to black so that it is consistent when printed in B&W.
Repeat for each different series. I tried this with one of my reports and it seemed to work OK. Is that what you were looking for?
0
 
xav056Author Commented:
I tried that , but that changes it for all the bars, I will set all the bars to have the same pattern
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
Megan BrooksSQL Server ConsultantCommented:
That's odd. Maybe what you are doing is not tied to different series. The series properties are what gives you control over the fill properties. You can also have categories. I haven't worked with those but the way they work should be similar.
If the bars are coming out in different colors now and you locate the fill property that sets those different colors (it might be set to "automatic") then, wherever you found that property you should be able to change the color to black and select a pattern. But I am surprised that it isn't the series fill properties.
There are many ways to customize the chart controls. Do you have an example of what you are doing?
0
 
xav056Author Commented:
I have the category and the series set, however If I choose the series properties and change the fill to pattern and the color to black that will make everything black, I also have to choose a pattern, there is  not auto option in the pattern, thus why I am always getting the same pattern for all the bars

Thanks
0
 
Megan BrooksSQL Server ConsultantCommented:
You would manually set a different pattern for each series, as above, for each series.
0
 
xav056Author Commented:
I only have one series with different bars
0
 
Megan BrooksSQL Server ConsultantCommented:
Somewhere you are getting different colors. Is it from the categories?
0
 
xav056Author Commented:
If I only had categories I would get one color only, What I am doing is dropping the field in the category into the series part as well, this seems to generate different colors for each column
Thank you
0
 
rob_farleyCommented:
David Lean has a series of posts on how to set the Color programmatically for each Category. You should be able to modify it simply enough to set the pattern instead.

http://blogs.msdn.com/davidlean/archive/2009/02/17/sql-reporting-how-to-conditional-color-2-4-functions-for-tables-charts.aspx

Rob
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.