Solved

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

Posted on 2012-04-02
3
577 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
  • 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS 2008 Report 2 Tablix on same page break? 4 51
SSRS  integration 5 98
sql query to reportserver  table error 3 50
Install SSRS for developer 1 31
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. …
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

840 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