Solved

SQL 2005 SSRS Printed Color Control

Posted on 2014-01-08
4
319 Views
Last Modified: 2014-09-08
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
Comment
Question by:SurferJoe
  • 3
4 Comments
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 39766057
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
 
LVL 4

Author Comment

by:SurferJoe
ID: 39766686
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
 
LVL 4

Author Comment

by:SurferJoe
ID: 40311102
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
 
LVL 4

Author Closing Comment

by:SurferJoe
ID: 40311103
Don't have time
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now