SQL 2005 SSRS Printed Color Control

We have a bunch of reports that render really nice in color. Of course not all colors print well in black and white.

Is there a way to strip the colors when the report is actually sent to the printer?
LVL 4
Greg RowlandSoftware Designer, SysDBA, WebMaster OwnerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
I'm not aware of any 'print only in black and white' property, but you could create an extra parameter @print, where 1=printing and 0=viewing, and in every control that has a BackgroundColor other than 'Automatic', 'Black', or 'White', enter this as a fill color expression

=IIF(Parameters!print.Value = 1, "Black", "The Screen Color")

Good luck.
Jim
0
 
Greg RowlandSoftware Designer, SysDBA, WebMaster OwnerAuthor Commented:
Hum, I'll try that.

I was hoping to come up with something that would go in "Report Properties, Code".
You see I have buttons in a Delphi app, that render report(s). Then the user prints using the print button in the browser.

As yet I have not figured out how do automate printing directly from the Delphi app.

Thank you for looking at this!

Greg
0
 
Greg RowlandSoftware Designer, SysDBA, WebMaster OwnerAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 500 points for Jim Horn's comment #a39766057
Assisted answer: 0 points for SurferJoe's comment #a39766686

for the following reason:

Don't have time
0
 
Greg RowlandSoftware Designer, SysDBA, WebMaster OwnerAuthor Commented:
Don't have time
0
All Courses

From novice to tech pro — start learning today.