Solved

SQL 2005 SSRS Printed Color Control

Posted on 2014-01-08
4
323 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:Greg Rowland
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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:Greg Rowland
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:Greg Rowland
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:Greg Rowland
ID: 40311103
Don't have time
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Query Task 11 44
Need help with another query 10 40
UPDATE JOIN multiple tables 5 24
SQL 2012 Instance Problem 3 63
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

697 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