Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
546 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Making Reporting Services use consistent chart colours |
---|
A simple way to ensure that SSRS allocates colours consistently to different charts in an embedded table |
It's not often these days that I find out something new about SQL Server Reporting Services (SSRS)!
So supposing that you have created a table, and embedded a chart within it:
Each chart is showing a breakdown of films by certificate for each studio, but the colours used for each certificate aren't consistent because of the way that SSRS assigns them from the palette.
Previously to solve this I had always told people to go to the fill colour of the chart, and use a SWITCH function to set the colours for each category. However, I've now discovered that you can change each category's group properties:
In the chart's data panel choose to change your category group's properties as shown above.
You can then tell SSRS to synchronise colours correctly:
Choose to synchronise your groups within your table. I'm not sure this is a brilliant explanation of what you want to do, but the results (below) speak for themselves.
This results in each category being accounted for, even if that instance of the group doesn't have values:
The colours are now consistent!
Now why didn't I know this before?
Some other pages relevant to the above blog include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.