Define Printer in Report

I have a client who tells me in Access you could assign the printer directly to the report using PrtDevNames and PrtDevMode. Apparently it's true.

Can this be done in Reporting Services?

check out the section "Direct Client Printing" in this link:

http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx

Shyam

|||

Thank you for the response.

Although that is a nice feature in 2005 over 2000. It's not quite what I am looking for I don't think.

I want to be able to store which printer the report should be sent to when printed so the user does not have to, I am looking for the same functionality that is in Access I mentioned above.

Default Printing Option for Crystal Report

I have developed a PDF web report which opens in a browser by using Crystal Report for VS.NET 2003. Is there any way to capture the printer settings of the users (who view this report) and change the Printer Paper Size to Legal? I understand that this is a security issue and this is not permitted under normal circumstances...but is there a round about way? My OS is Windows 2003.
Thanks for your helpIf I understand your question correctly, here's how I do it in VB 6 and CR 8.5 using RDC (maybe you can manipulate it to fit your needs?).

Report.PaperSize = crPaperLegal
Report.PrintOut

This way, you don't have to change the user's settings.

Default Printer settings

I have an issue with default papaer size and margin sizes. My printer is
configured with a default paper size of A4, every time I print a report with
the print control it defaults to Letter. So I have to hit the go button to
the print to run.
Secondly the default margin sizes are 12.7mm (1/2 inch), I woudl like to
reduce this to 5mm (@. 3/16 inch). I have had a similiar issue with blank
pages and found reducing the default print margin control to something less
than 1/2 inch sorts this out.
Is there a congfig file setting that I can change to make these printer
settings stick?
thanks
RayThe print control will use the margins set in your report. If you do not
set the margins, it will default to half an inch.
--
| Thread-Topic: Default Printer settings
| thread-index: AcVKL/UhL/9g9tA8Qqi+9Q5klGKalQ==| X-WBNR-Posting-Host: 203.10.231.231
| From: "=?Utf-8?B?UmF5IFNlcHBhbGE=?="
<Ray.Seppala@.defence.gov.au.(Donotspam)>
| Subject: Default Printer settings
| Date: Tue, 26 Apr 2005 00:17:08 -0700
| Lines: 16
| Message-ID: <6315458B-6B62-4F09-AFC1-76E19A8B4ABD@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:41806
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I have an issue with default papaer size and margin sizes. My printer is
| configured with a default paper size of A4, every time I print a report
with
| the print control it defaults to Letter. So I have to hit the go button
to
| the print to run.
|
| Secondly the default margin sizes are 12.7mm (1/2 inch), I woudl like to
| reduce this to 5mm (@. 3/16 inch). I have had a similiar issue with blank
| pages and found reducing the default print margin control to something
less
| than 1/2 inch sorts this out.
|
| Is there a congfig file setting that I can change to make these printer
| settings stick?
|
| thanks
|
| Ray
||||Thanks,
I have since found out that I have to re-publish all my reports for RS SP2
to be able to read each Report's print layout and margin settings.
Thanks for the the reply Brad!
""Brad Syputa - MS"" wrote:
> The print control will use the margins set in your report. If you do not
> set the margins, it will default to half an inch.
> --
> | Thread-Topic: Default Printer settings
> | thread-index: AcVKL/UhL/9g9tA8Qqi+9Q5klGKalQ==> | X-WBNR-Posting-Host: 203.10.231.231
> | From: "=?Utf-8?B?UmF5IFNlcHBhbGE=?="
> <Ray.Seppala@.defence.gov.au.(Donotspam)>
> | Subject: Default Printer settings
> | Date: Tue, 26 Apr 2005 00:17:08 -0700
> | Lines: 16
> | Message-ID: <6315458B-6B62-4F09-AFC1-76E19A8B4ABD@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:41806
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I have an issue with default papaer size and margin sizes. My printer is
> | configured with a default paper size of A4, every time I print a report
> with
> | the print control it defaults to Letter. So I have to hit the go button
> to
> | the print to run.
> |
> | Secondly the default margin sizes are 12.7mm (1/2 inch), I woudl like to
> | reduce this to 5mm (@. 3/16 inch). I have had a similiar issue with blank
> | pages and found reducing the default print margin control to something
> less
> | than 1/2 inch sorts this out.
> |
> | Is there a congfig file setting that I can change to make these printer
> | settings stick?
> |
> | thanks
> |
> | Ray
> |
>