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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

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
xav056Author Commented:

What is was looking for is achievable by chossing the greyscale pattern from the pallete property Thanks
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.