?
Solved

SQL 2005 SSRS Printed Color Control

Posted on 2014-01-08
4
Medium Priority
?
341 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 66

Accepted Solution

by:
Jim Horn earned 1500 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

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

770 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