• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3004
  • Last Modified:

From VB set Paper Size of Crystal Report

I am printing reports from Visual Basic 6.0 using Crystal Reports version 8.

My Reports have been saved with the printer setup using A4 paper.

I need the reports to stay as they are but within my VB Code, be able to change the paper size to Letter.

Is this possible?
0
jarvoid
Asked:
jarvoid
  • 3
  • 3
  • 3
  • +1
2 Solutions
 
duobaCommented:
Here is some sample code

obviously you first need to create the report.  before you run the rerport through your code you
set the papersize to letter like this

    Report.PaperSize = crPaperLetter

Report being the name of the report not the crviewer.
0
 
jarvoidAuthor Commented:
I have no PaperSize property.

How do I get it?
0
 
duobaCommented:
what is the value(report) you are setting your crviewer report source to.

This value(report) should be the report you have created and papersize should be a property.

send your code through and Ill have a look at it.  
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
duobaCommented:
Also have you got the correct refrences?
I have
-crystal reports activx designer runtime library
-crystal reports activx designer design and runtime library
and you obviously must have crystal report viewer control
0
 
jarvoidAuthor Commented:
Components:
Crystal Report Control ticked.
Crystal Report Viewer Control Unticked.

References:
Crystal Report 8 ActiveX Designer Run-Time Library

I have a Crystal Report Control on my form.

CrystalReport1.ReportFileName = "ListTest.rpt"
result = CrystalReport1.PrintReport

I don't think I use the Crystal Report Viewer control - I have a separate full version of Crystal Reports.
0
 
jarvoidAuthor Commented:
Thanks for your help peoples - unfortunately it looks as though it is not possible without the use of the Crystal Report Viewer control which I do not use.  I use the control entitled "Crystal Report Control" (Crystl32.ocx)

I have a project with 200 reports all going to A4.  I may just have to duplicate each report and send the duplicated ones to Letter and choose the report based on a flag.  I was just hoping there was an easier way...
0
 
mlmccCommented:
YOu can use the printer select form and then set the properties when you run the report.

crRpt.PrinterSelect

mlmcc
0
 
CleanupPingCommented:
jarvoid:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
mlmccCommented:
Glad I could help

mlmcc
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 3
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now