conditional formatting - 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)

conditional formatting

Author

Topic

bencantello
Starting Member

10 Posts

Posted - 2008-04-02 : 17:14:38

hey there I have a series of finacial reports. the girls that work on them want color and the boss wants them to print in black and white. the color back grounds print grayscale so I would like to add a link of some sort that changed the background to transparent when they want to print a report.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-04-02 : 17:31:53

do the formatting in your front end.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

bencantello
Starting Member

10 Posts

Posted - 2008-04-02 : 17:40:09

i'm sorry but i am really new to sql and am not sure what you mean by "front end"

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-04-02 : 17:43:40

ok.. first tell us where would you like to change the formatting?
sql server is a server to which clients connect. a client is a front end.
a client can be your asp.net or windows forms application, SQL Server management studio, sql profiler, etc...

so what is your client on which you want to change the formatting?

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

bencantello
Starting Member

10 Posts

Posted - 2008-04-02 : 17:52:28

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-04-02 : 17:57:35

so you're reffering to reporting services?

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

bencantello
Starting Member

10 Posts

Posted - 2008-04-02 : 18:00:11

Yeah

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-04-02 : 18:08:30

ok i have no idea about reporting services (sorry...) but i'll move this to appropriate forum.
this link might help you:
http://www.sqlservercentral.com/articles/Development/reportingservicesconditionalformatting/1423/

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

bencantello
Starting Member

10 Posts

Posted - 2008-04-02 : 18:17:37

thanks

jhermiz

3564 Posts

Posted - 2008-04-03 : 10:14:17

quote:
Originally posted by bencantello

thanks

This is very very simple. Just create a parameter in the report called say Color?
When the user Selects 'Y' it shows the report in color, else it doesnt.

Then in each text box in your report you put conditional formatting so that the color does an if

=IIF(Parameters!Color.Value = 'Y', "Red", "Black")

Thats it

Jon

Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-03 : 10:39:42

quote:
Originally posted by jhermiz

quote:
Originally posted by bencantello

thanks

This is very very simple. Just create a parameter in the report called say Color?
When the user Selects 'Y' it shows the report in color, else it doesnt.

Then in each text box in your report you put conditional formatting so that the color does an if

=IIF(Parameters!Color.Value = "Y", "Red", "Black")

Thats it

Jon

Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]

small typo

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources