Changing colours - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Changing colours

Author

Topic

cipriani1984
Constraint Violating Yak Guru

304 Posts

Posted - 2009-09-14 : 09:03:27

Hi,

Ive got a matrix up and I would like for each group to be a different colour.

Im using the following code at the moment:

Function GetColour (Input) As String
if (Value > 1000) 'Red'
ETC
Return 'Light Green'
End function

---------------

Is there any other way to just seperate out the groups in the matrix but different colours without having to specify rules?

Regards,

Cipriani

freezea
Starting Member

5 Posts

Posted - 2009-09-14 : 10:49:16

Hi, cipriani1984.
You can use RAQ Report to solve your problem. First, you can make your group report easily. Then, in the properties bar, you can set different background colour for each group just by clicking your mouse.

Welcome to my blog at http://freezea.blogspot.com/.

cipriani1984
Constraint Violating Yak Guru

304 Posts

Posted - 2009-09-14 : 11:07:38

Thats not really solution, its just installing a new programme, there must be a inbuilt way of doing it surely?

Thanks,

Cipriani

quote:
Originally posted by freezea

Hi, cipriani1984.
You can use RAQ Report to solve your problem. First, you can make your group report easily. Then, in the properties bar, you can set different background colour for each group just by clicking your mouse.

Welcome to my blog at http://freezea.blogspot.com/.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-09-14 : 11:32:40

quote:
Originally posted by cipriani1984

Hi,

Ive got a matrix up and I would like for each group to be a different colour.

Im using the following code at the moment:

Function GetColour (Input) As String
if (Value > 1000) 'Red'
ETC
Return 'Light Green'
End function

---------------

Is there any other way to just seperate out the groups in the matrix but different colours without having to specify rules?

Regards,

Cipriani

there's a color property for textbox of matrix. you need to write an expression based on your rule to set the color value as per your group. i think what you need to look for is function Inscope()

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources