PaperSource

Ciao, I'm using CRAXDDRT automation for printing reports in Crystal Report 10.
I would like to choose the paper source (i.e.: Tray1, Tray2...) for a HP printer.
I use this command:

crystalReport.SelectPrinter "", "", "" TO SET DEFAULT PRINTER
crystalReport.PaperSource = 261 TO SET TRAY1

That printer has 2 trays: if I set for printing on Tray1 but there's no paper into it, tray2 is automatically selected.
I don't want this! I want that a message is prompted in vb code or on the display of hp printer, I want to know that tray1 has no paper and print must be stopped.

How could I do this? Do it depend from the printer type? Is it possible or is it normal that the first tray with paper is used?From what I understand, you can only control the papersource property when the report is not being formatted for printing. So after you open the report, you must set this property before you connect to server and start pumping data into it via the PrintOut method.
Also, the value you should be passing for the upper bin is 1 (crPRBinUpper =1, crPRBinLower = 2), not 261 as your notes show.

dave|||First of all, sorry for my english and thanks for repling me!

With HP Printers upper bin are not good, they need a 'personal code' (261, 262 and so...).
Searching on the internet I've found info about that: after setting the default printer I must pass the tray I need to print.
It works right only if paper is in both of trayes but if a tray is empty it prints automatically using the other one.
Instead of this I would like to know (directly on the printer display or trhrought VB code) if a tray is empty so I can choose to use the other or cancel all.

I hope you understand, but I think there's no solution because I haven't found nothing on the web about this and nobody can help me :(|||Well, if you have a licenced copy of Crystal reports, you had better contact them and ask for a fix.

Dave|||I had a similar problem, passing printer parameters from winspool to an external .net printer appi.

to deal with this in .net, ref. the Crystal 10 CrystalDecisions.CrystalReports.Engine (ver. 10.0.3300.0? assembly)

dont use papersource, this is an enumerated standard.

use CustomPaperSource to set the source from the passed string after the PrinterName is set

code snip:

'Source
Dim m_PrinterSettings As New Printing.PrinterSettings
Dim m_PaperSource As System.Drawing.Printing.PaperSource
Dim m_PrinterSource As Printing.PaperSource
Try
For Each m_PrinterSource In m_PrinterSettings.PaperSources
If m_PrinterSource.SourceName.ToString = <my paper source> Then
m_PaperSource = m_PrinterSource
Exit For
End If
Next

crReportDocument.PrintOptions.CustomPaperSource = m_PaperSource
Catch
'just default to auto if problem
crReportDocument.PrintOptions.PaperSource = CrystalDecisions.[Shared].PaperSource.Auto
End Try

CustomPaperSource is not coded in the 9.x assembly(s)

there is a crystal descision KB article somewhere out there on this.
hope this helps.

Paper Based Reports Support

Hi,
I am a newbie to SQL Reporting Services. I am trying to evaluate whether to
use SQL reporting services as opposed to crystal reports. I want to create
paper based reports as well as web based reports. Is it fair to say that
SQL Reporting Services focuses more on web based reports than on paper based
reports? I know that it can export reports in an Excel and PDF format but
that seems to be the full extent of true paper based reporting. Am I
missing something? Will there be more support for paper based reports in
the future?
Thanks,
VaughnDepends on what you mean by paper based reports. RS is a format independent
reporting solution. The report is specified via the RDL (if you look at the
RDL it is an xml file). The report definition says how the data should be
formated. How it is formated (rendered) depends on what you ask RS to do.
The default is HTML but that is just the default and really it is just one
of the rendering formats. When you see the export all that is happening is
RS is being asked to run the report but using a different rendering format.
PDF is the format that is used for printing today. With SP2 there will be a
print button on the toolbar which will provide client side printing so you
do not have to go through exporting. My guess (only a guess, no inside
knowledge) is that we will see SP2 sometime first quarter next year.
One thing that I do consider paper based that they do not yet handle well is
the whole issue of labels. For instance being able to easily design a report
for particular labels. In MS Access they have a wizard for this. The wizard
really doesn't do anything that couldn't be done in the GUI designer but it
makes it very easy to do so. It would be nice to have something like this in
RS.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vaughn" <vhaybittle@.mweb.co.za> wrote in message
news:%23Ce6mq51EHA.1152@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I am a newbie to SQL Reporting Services. I am trying to evaluate whether
to
> use SQL reporting services as opposed to crystal reports. I want to
create
> paper based reports as well as web based reports. Is it fair to say that
> SQL Reporting Services focuses more on web based reports than on paper
based
> reports? I know that it can export reports in an Excel and PDF format but
> that seems to be the full extent of true paper based reporting. Am I
> missing something? Will there be more support for paper based reports in
> the future?
> Thanks,
> Vaughn
>

Paper about SQL Server 2005

Hey,

did anyone know a good paper or a good ms link about SQL Server 2005 -
because I have problems to install the Beta Version..

thanks very muchHi

SQL 2005 Beta newsgroups:

http://communities.microsoft.com/ne...ver2005.express

Regards
----------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@.epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Philipp" <Philipp_Gufler@.yahoo.de> wrote in message
news:42597997$1@.e-post.inode.at...
> Hey,
> did anyone know a good paper or a good ms link about SQL Server 2005 -
> because I have problems to install the Beta Version..
> thanks very much

Page Size

Hi,
How can I define Page Size.Orientation in Report Designer?
I am looking for some way to define letter/legal size paper and also
Landescap/Portrate paper orientation.
Can users change those printig attributes when they are printing/expoting
that to PDF file?
Thank,
AlanYou can change the page width and page height to 11 x 8.5 instead of 8.5 x
11 inches in the report designer. You can find these properties in the
Report | "Report Properties..." menu item, select the Layout tab.
A user can change the Rendering attributes when they view a report via the
ReportServer web service. For example, to retrieve a PDF report rendered
with a height of 15 inches instead of the default 11 inches, a user would
use this URL:
http://servername/ReportServer?/Project1/Test_Report1&rs:Command=Render&rs:F
ormat=PDF&rc:PageHeight=15in
The user's printer settings is up to them but it would look best if the
rendering parameters match the printer parameters. For more information
see the Reporting Services Device Information Settings page on MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
rsp_prog_soapapi_dev_5l7q.asp?frame=true
Jonathan Kyle, MCSD
Microsoft WebData Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "A.M" <nospam1@.online.nospam>
>Subject: Page Size
>Date: Tue, 7 Sep 2004 13:42:04 -0400
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
>Message-ID: <#MFqkGQlEHA.3520@.TK2MSFTNGP11.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: 209.226.40.154
>Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11