Link to home
Create AccountLog in
SSRS

SSRS

--

Questions

--

Followers

Top Experts

Avatar of Lupo09
Lupo09🇩🇪

SSRS 2008 chart: set line colors
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 :-)

User generated image

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


Avatar of ValentinoVValentinoV🇧🇪

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.

Avatar of Lupo09Lupo09🇩🇪

ASKER

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.

ASKER CERTIFIED SOLUTION
Avatar of ValentinoVValentinoV🇧🇪

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account

Avatar of Lupo09Lupo09🇩🇪

ASKER

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!

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.


Avatar of ValentinoVValentinoV🇧🇪

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!

Avatar of Lupo09Lupo09🇩🇪

ASKER

Interesting idea!

I will think aboout it,
thanks!

Avatar of ValentinoVValentinoV🇧🇪

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

Free T-shirt

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


Avatar of Lupo09Lupo09🇩🇪

ASKER

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!
SSRS

SSRS

--

Questions

--

Followers

Top Experts

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.