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
![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 ?
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
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
15 People are following this question.
