Apprearnce of the report using report parameter

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 2008 Forums

Analysis Server and Reporting Services (2008)

Apprearnce of the report using report parameter

Author

Topic

chinlax
Starting Member

30 Posts

Posted - 2011-11-22 : 23:56:46

Hi All,

I want to change the color of the report based on the report parameter.
I have table employee.it has the following colmuns

empno ename job sal deptno

based on the deptno the color has to be changed

if deptno=10, the colour should be red.
i wrote the expression in tablix properties, inside the filter option

like this :
=IIF(Fields!job.Value = Parameters!ReportParameter1.Value, "Red", "Black")

it is not showing data its just displaying the clomn names.

Can any one help me out.

Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-23 : 00:04:07

you should be giving this expression inside Color property of textbox not inside textbox itself

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

chinlax
Starting Member

30 Posts

Posted - 2011-11-23 : 01:37:47

Where do we find color property of the textboxes. can u please tell me.

As i am new to SSRS , i dont know where to write the expression

Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-23 : 01:44:53

quote:
Originally posted by chinlax

Where do we find color property of the textboxes. can u please tell me.

As i am new to SSRS , i dont know where to write the expression

Thanks

select the cell where you show the required data and choose view-> properties window option from the menu on top (or just click F4 key)
It will open properties window on right hand side and you can see Color property inside that which needs to be changed to suggested expression.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

chinlax
Starting Member

30 Posts

Posted - 2011-11-23 : 02:14:12

Yes i got it,
it is for particular cell, color will change

But if i want to get change the color for the entire row .

say i want to make the color 'green' for those employees getting less than 2500 and make it 'red' for those employees getting more than 2500

how to do it, can u guide me how to approach it.

Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-23 : 03:01:09

same approach. only difference is you will select the entire cells in row by pressing ctrl key and then do same steps as above

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources