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
Solved

SSRS 2008 chart: set line colors

Posted on 2014-01-09
8
1,433 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
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

 

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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
SQL Server agent & maintenance task issue ? 8 76
SSRS expression Issue finding a string 10 89
SSRS Expression IIF Statements 2 58
performance query 4 32
In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
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…

790 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