SSRS
--
Questions
--
Followers
Top 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 :-)
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
The line style is set through the Border page.
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.
My apprach is:
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!






EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
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!
I will think aboout it,
thanks!

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.
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
--
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.