Solved

SSRS 2008 chart: set line colors

Posted on 2014-01-09
8
1,442 Views
Last Modified: 2014-01-15
Hi experts,

I have an issue on a line chart.
My chart plots project hours for 12 months:
    x-axis: jan to dec,
    y-axis: total of hours

I have 2 value groups: plan-hours and actual hours for each project.

Now I want the report to plot the values for plan and actual using the same color but using a different pattern, so that each project gets the same color.

I have attached a screenshot of my chart definition in SSRS for more details on my chart.

Does anybody have a clue on that?

Thanks a lot in advance :-)

Chart definition in SSRS
0
Comment
Question by:Lupo09
  • 4
  • 4
8 Comments
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39768084
To give them the same color: right-click each line in the designer and select Series Properties.  Switch to the Fill page and specify your preferred color.

The line style is set through the Border page.
0
 

Author Comment

by:Lupo09
ID: 39768277
Hmm, that won't work as the user is free to select as many projects as he wants.

I don't know how many lines there will be at run time, I only know that each project will be represented by two lines: one cor the actual values and one for the plan values.
0
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 39770284
Ow right, I see what you mean now!  In that case the approach needs a little more creativity.  To ensure that each project uses its own color the best option is to add a color field to your dataset.  Hopefully your query can be edited?  Let me know if you need help with this part. (Currently I don't even know what your data source is, but I assume a regular SQL Server DB?)

Once you've got the color field in the dataset you can just use that in the Color property of both series.
0
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 

Author Closing Comment

by:Lupo09
ID: 39770314
Yes that works as a workarround (because i have to foresee the maximum number of projects that may be selected).

My apprach is:
In my SQL string I use the DENSE_BANK() -clause in order to get a unique number for each project
Then I use the case clause to assign a color to the first 20 numbers
I have to do it that way since I have some 100 projects, I cannot assign colors to each project. Instead I find the number of selected projects which I limit to 20 (only up to 5 or 6 are sensible I think)

Now I have a color for each project in the selected resultset.
And now I can assign the color field to both of the series and use different patterns in order to distinguish them.

Thanks!
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39770442
Glad to hear you got it to work!  And indeed, limiting the number of projects seems sensible, the chart becomes unreadable otherwise anyways...

Something I was thinking: as you may already know, SSRS uses color codes represented in RGB and a color consists of three times a number in the 0 - 255 range in hexadecimal.  As you've given each project a unique number perhaps it's an option to come up with a formula that generates a unique color code per project instead of hard-coding the actual colors.  Some food for thought :)

Good luck with the project!
0
 

Author Comment

by:Lupo09
ID: 39770469
Interesting idea!

I will think aboout it,
thanks!
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39770471
BTW: I just noticed you've given my answer a B-grade, what's the reason for that?
0
 

Author Comment

by:Lupo09
ID: 39781641
Oh, hey...

yes, I thought, I figured out a proper way to assign colors to projects on my own, and this is "only" a workarround since the number of selectable projects is limited (which is not a real problem in reality, of course).

Thanks!
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Updating statistics with error notification email in SQL server 4 118
Grid querry results 41 82
SSRS MONTHNAME and IIF 16 83
SSRS Deployment problem 5 91
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

735 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