question

prashanthkumar043 avatar image
prashanthkumar043 asked

dynamic coloring in SSRS group wise

Hello EveryOne, I have a requirement, In SSRS reports how to dynamically set color for series in each group. Example:- Group A contains (1,2,3,4,5) Group A contains (10,21,5,1,15) Length is not fixed it may vary.In my SSRS Report i want to apply same color for 5,1 in both the groups.Groups also may increase.I was tried with some VB Code in Code expression in SSRS. Thanks, Prashnath
dynamic
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

You mean Background - Alternating Colors for Each Group For instance - * Group A - 1, 2, 3, 4, 5 (Blue or any) * Group B - 10, 21, 5, 1, 15 (Red or any)
0 Likes 0 ·
ssharma14 avatar image
ssharma14 answered
![alt text][1] [1]: /storage/temp/1431-alternating+group+color+capture.png REFER to my screen shot and advise where exactly you want to dynamically set color - and are you looking to alternatively change color by group ?

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

prashanthkumar043 avatar image
prashanthkumar043 answered
Thanks for Responds, In my report i am using column chart.It showing month wise data.For each month contains some types(like:Jan(a,b,c),Feb(a,b,c,d)). In this example suppose 'a' is Red color and 'b' is blue color like wise for all the months.In this the types(a,b,c) also may vary. My Requirement is i want to apply same color for 'a' in all the months. Whichever the color apply to 'a' for the first time that should apply for all the months.Like this apply colors for all types in all months. In the attached image January shows some colors,i want to apply that colors to other months.Months may vary and bars may vary. Thanks, Prashanth M![alt text][1] [1]: /storage/temp/1435-monthtypes.jpg

monthtypes.jpg (31.8 KiB)
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Prashant to answer your question I need to know the Data fields, Series fields and your category fields. If you go to the design and double click anywhere within the chart area - it will read it for you. So attach that - would be much helpful.
0 Likes 0 ·
prashanthkumar043 avatar image
prashanthkumar043 answered
Thanks ssharma, I have attached the screen with the Data fields, Series fields and category fields. In this report i am getting the data from cube. category is Month name and series is Type name and count. Appreciate your quick response. Thanks, Prashanth ` `![alt text][1] [1]: /storage/temp/1439-bymonth.jpg

bymonth.jpg (124.5 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.