Group wise alternate color in SSRS 2005
hi,
I Created a report in SSRS 2005. for this I need to apply alternate color for each group instead of alternate rows. please help me...
Thanks in Advance,
Krishna.
June 22nd, 2011 3:22pm
Hi Krishna,
Can you paste your ReportDesign Layout here.
Rakesh M J
Dont forget to mark it as Answered if found useful
MCTS,MCITP,MCSS
http://mycubeandreports.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
June 22nd, 2011 3:39pm
Hi,
Following is the report format. But after pasting the table, in group some area is converting to white background, consider that also in gray color.
Group
Resource Office
Role
Total Staff
Project Status
2011
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Mechanical Engineering
Kansas City
Mech AQCS
1.0
Active
1.0
1.0
1.0
1.0
1.0
1.0
1.0
1.0
NB Forecast
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
Sub-Total
1.0
1.0
1.0
1.0
1.0
1.0
1.0
1.0
1.0
Mechanical Engineerng
Kansas City
Mech Assistant PDE
11.0
Active
11.0
11.0
9.5
9.5
9.5
5.0
5.0
5.0
NB Forecast
0.0
0.0
0.0
0.0
0.0
5.0
5.0
5.0
Sub-Total
11.0
11.0
11.0
9.5
9.5
9.5
10.0
10.0
10.0
Mechanical Engineering
Kansas City
Mech Design Engineer (0801-0803)
26.0
Active
23.0
23.0
20.8
19.5
16.0
14.7
13.7
3.0
NB Forecast
0.0
0.0
0.0
4.0
4.0
4.0
6.0
6.0
Sub-Total
26.0
23.0
23.0
20.8
23.5
20.0
18.7
19.7
9.0
Mechanical Engineerng
Kansas City
Mech Equipment
11.0
Active
11.0
11.0
9.5
9.5
9.5
5.0
5.0
5.0
NB Forecast
0.0
0.0
0.0
0.0
0.0
5.0
5.0
5.0
Sub-Total
11.0
11.0
11.0
9.5
9.5
9.5
10.0
10.0
10.0
Thanks in Advance
Krishna.
June 22nd, 2011 3:55pm
Hi Krishna,
According to your description, you would like to apply alternate color for each group, right?
If that’s the case, please refer to the following link for more details,
Alternating Group Colors and Alternating Row Colors:
http://www.bidn.com/blogs/briankmcdonald/bidn-blog/717/alternating-group-colors-and-alternating-row-colors
If you have any question, please feel free to ask.
Thanks,
EIleen
Free Windows Admin Tool Kit Click here and download it now
June 28th, 2011 10:57am