562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls 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
|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?
25 Aytoun Street