• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 380
  • Last Modified:

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?
0
Greg Rowland
Asked:
Greg Rowland
  • 3
1 Solution
 
Jim HornMicrosoft 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now