Solved

Matching the grid data row colors with the pie chart portion colors in SSRS

Posted on 2012-04-02
3
582 Views
Last Modified: 2012-08-14
Assume that you have a list of countries with a value beside each of them.  Now build a pie chart.  Assume also that you will show the same data as a grid beside this pie chart.

How to color the the country row in the grid, and it's portion of the pie sclice with the same color?  If we were to show the results with a continent grouping countries within it, I would like to this within each group.

I appreciate your help.
0
Comment
Question by:tikkub
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 37799497
It could be that ensuring both the pie and the table use the same sort order is sufficient, but I doubt it.  You're probably going to need to look into setting up custom coloring so that you have full control over what country gets what color.

Have a look at the following article to get you started, it explains how to set up custom coloring on the pie chart: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/A_1884-Pie-Chart-Techniques.html
0
 

Author Closing Comment

by:tikkub
ID: 37801441
You are very good.  The article had the idea about using color in the dataset.  Ultimately, that is the cleanest way of doing it.  Being a data guy, I prefer putting things out using data set rather than writing code in the report.  I appreciate your help.
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 37802282
Thank you tikkub, and I totally agree with that! :)
0

Featured Post

Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question