Visual Basic :: Print Crystal Report On Dot Matrix Printer

Trying To Print Crystal Report Directly To Printer
Hi,

I am trying to print crystal report directly to network printer without viewing the report through ASP. This was working on NT4 Server, IIS. I installed shared printer on NT 4, register these printers in the registry and then printed directly to these printers through ASP.

Now we have 2000 server. Did the same on 2000 server, but when ASP page is called, Selectprinter as well as Printout method do not return any error code but still report is not printed to the printer. Can you help me with the same?

Print Directly To A Printer Using Crystal Report Viewer
Dear all,

How can I print a report directly to a printer without showing the report?
e.g. User select a number (ex. CI00001) from Customer Invoice Form. There are 2 active toolbar icon: Print and Preview. When a user click Preview icon button then the Customer Invoice No. CI00001 report will show, and when a user click Print icon button, the Customer Invoice No. CI00001 will directly print to a printer without previewing the report.
I have no problem in Previewing the report.

Please share.

Print On Dot Matrix Printer...
My Dears,

Please help! I'm using VB6, MSSQL 2000 on Windows XP... LX-300+ printer installed (using continous paper)
My problem is:
My code is working fine, but I want to print using dot matrix printer without pulling the full page after printing one receipt. When i print to certain portion of the page, the printer should stop and wait for another print command. I think it could be usefull for printing receipts like cash registers in the malls for saving papers and also for pre-printed receipts.

Could it be possible? please help!

How To Print With An Dot Matrix Printer????
Hi Guys

I am developing an inventory control software and I need to print some invoices.

Can you please tell me how to send output for the dot matrix printer I am using the datareport for this. I am confused about the row and columns size of the paper used in dot matrix printer....... I mean how to set these according to report on screen. I tried to set up but report give error report width is more than screen....

Any help please

Thanks

Hope Never Ends Keep On Doing Hard Work
Jaspinder Singh

How To Print Using Vb6 To Dot Matrix Printer
Hi everybody,

I normaly use crystal reports with vb6, now one of my client got pre-printed invoices for their billing... And that print only with epson dot matrix printer.

I do not know how can i print the invoice without using crystal reports..

It will highly appreciated if anybody can help me in this regard...

Also please tell me how to set the page setup for this invoices....

thanks a lot in advance

Stephan

Print 1/3 Of A Page W/Dot Matrix Printer
Hi All!

I have written many apps which print forms, textboxes,etc., but his latest app has me bouncing off the walls. I have an automated ticket generator for a truck scale. Imagine this: an Okidata Dot Matrix printer, which feedsthe paper via carriage wheel. Each 8.5 x 11 carbon-copy paper is actually divided into three carbon-copy tickets separated by perforations.

My problem is this: I have drawn a form which fits on each ticket(1/3 of the page) quite well. However, I cannot figure out how to make the printer feed ONLY 1/3 OF THE PAGE after each spool. What ends up happening is a whole page is fed in, and two tickets are wasted each print. Of course, I could just tell the guy to feed the paper backout after every ticket, but then he would have to worry about lining it up correctly every time.

If anyone has any ideas, I would really appreciate it
Thanks For Your Time

Print Greek Chara Ters In Dot Matrix Printer
Hi,

I am writing a program which is supposed to ptint text boxes in a Dot Matrix Printer (Seico SP 2400). The text in the text boxes is Greek. However, each time I convert the text string into Asc before I print it, the code I get doesn't represent any usuable characters from the Ascii (IBM) table.

However, when I type english characters everything works fine. Do you have any ideas how can I print the Greek text in my printer.

Thanks a lot for your help!
H.

How To Create A Text File To Print On A Dot Matrix Printer
How to print on a dot matrix printer. When we start printing it takes long time to print a page. Suppose we want to print a company's Invoice using dot matrix printer. Is to possible to make a text file.

Dot Matrix Printer With Crystal/word Docs
Does anyone know of any reason why a word document or a crystal report would show as just dots and dashes on a dot matrix printer?

Crystal Report... How To Print Crystal Report Using PrintDocument??
Hi.. I need help greatly... there's an issue which required me to make use of the PrintDOcument Object to print this crystal report..Instead of the pre defined printer button on the crystal report viewer..???Can anyone teach me HOW to print crystal report using the print document??it just seems to can't capture the crystal report for printing.... ANd how do i make use of the PrintPage Event???

What's Logon Parameter To Oracle Server With Vb To Print Report With Crystal Report
Hi all,

How to write a log on parameter to oralce server with using vb to print a report that using crystal report

is it crystalreport1.connect = "Dsn=servername;uid=username;pwd=password"

and how to use the selectionformula

Show Print Dialog When Printing Report With Crystal Report
Hi there,

In my code when I press on the printing button I want it to show the printing dialog to choose printer and tray which I will print out.

My code like this:

Public Report As CRAXDRT.Report
Set Report = crxApp.OpenReport(App.path & "Data
ptBDM.rpt")
Report.PrintOut true

With these code it only let me choose from page to page not for printer and tray.

Thanks a lots.

Using Print Engine API To Print Crystal Report From VB
I am trying to run a Crystal Report (ver 7) from a VB app (ver 6) using the
Print Engine API.
The report links to tables in an Oracle (ver 7.3.4) database via ODBC.
I use VB to collect the parameters to pass them to the report.
All seems to work fine until the end of this code when I try to display the
report.
The report window opens momentarily, then closes.
The last MsgBox reports an error code of 599.
I have been able to determine that apparently I need to Logon to the server.
However, there is not enough documentation on how to use PELogonServer or
PESetNthTableLogOnInfo.
Can someone enlighten me or at least point me to some decent reference
material?

'''### copy of code ###'''
Dim txtValu(2) As String
txtValu(0) = txtSDate.Text
txtValu(1) = txtEDate.Text
RptName = App.Path & "SO_003.rpt"

ParamInfo.StructSize = PE_SIZEOF_PARAMETER_FIELD_INFO
valueInfo.StructSize = PE_SIZEOF_VALUE_INFO

Handle = PEOpenEngine
job = PEOpenPrintJob(RptName)
ParamNum = PEGetNParameterFields(job)
For i = 0 To (ParamNum - 1)
Result = PEGetNthParameterField(job, i, ParamInfo)
valueInfo.valueType = PE_VI_DATE
valueInfo.viDate(0) = Year(CDate(txtValu(i)))
valueInfo.viDate(1) = Month(CDate(txtValu(i)))
valueInfo.viDate(2) = Day(CDate(txtValu(i)))
Result = PEAddParameterCurrentValue(job, ParamInfo.Name, _
ParamInfo.reportName, valueInfo)
If Result = 0 Then
ErrorNum = PEGetErrorCode(job)
MsgBox "The call PEAddParameterCurrentValue failed"
MsgBox "The error code is: " & ErrorNum
End If

Next i
Handle = PEOutputToWindow(job, RptName, 0, 0, 520, 520, 0, 0)
If Handle = 0 Then
ErrorNum = PEGetErrorCode(job)
MsgBox "The output cannot be sent to the window"
MsgBox "The error code is " & ErrorNum
Else
Handle = PEStartPrintJob(job, True)
If Handle = 0 Then
ErrorNum = PEGetErrorCode(job)
MsgBox "An error occurred while trying to start the Print Job."
MsgBox "The error code is " & ErrorNum
End If
End If

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~

How To Print Report Using DMP Printer
I want to print on Dot Matrix Printer as printed in msdos by making text file. I am using filesystemobject and textstream but it takes too much time. Plz Help

Print A Report To Printer
Perhaps I need a better book, but if I wish to print a report (columns of numbers) with a header, isn't there any helpful objects/functions? Not using a database. Using an array of my own class objects.

Thanks for any help.

John

Crystal Report, Print 3 Diff Copies Of A Report
Dear Friends

I am using crystal report 8 in visual basic 6, back end access 97. I want to print 3 copies of Invocie. Like first copy should be marked as "Original" Second "Accounts" and third "Record Copy".

I tried a lot but could not succeed. Please check out this

Zubair Khan

How To Change Printer Orientation Specially For Dot Matrix Printer?
I want to konw API to change Printer Orientation? How to do it?

Access Print Report To Same Network Printer
Maybe this is too easy and I am trying to think too hard about this.

I have a report in access97 that automatically prints when the first person logs into my database on Monday. I am trying to setup the report so that it always prints to the same network printer no matter which individual logs in or from where. (They must be on the network to log in).

[Beenprinted] is just a check box in the forms underlying table that is used to make sure the report isn't printed twice on Monday. Here is the code that I want to add to so the report will always print to one particular network printer.

Code:
Private Sub Form_Load()
On Error GoTo Form_Load_Error

Dim Todaysdate As Integer
Todaysdate = DatePart("w", Now)

Select Case Todaysdate
Case 1
If Me![beenprinted].Value = True Then
Me![beenprinted].Visible = True
Me![beenprinted].Value = False
Me![beenprinted].Visible = False
End If
Case 2
Dim stDocName As String

If Me![beenprinted].Value = False Then
stDocName = "rptContactBackNext7All"
DoCmd.OpenReport stDocName, acNormal
Me![beenprinted].Visible = True
Me![beenprinted].Value = True
Me![beenprinted].Visible = False
End If
Case 3
If Me![beenprinted].Value = True Then
Me![beenprinted].Visible = True
Me![beenprinted].Value = False
Me![beenprinted].Visible = False
End If
Case 4
If Me![beenprinted].Value = True Then
Me![beenprinted].Visible = True
Me![beenprinted].Value = False
Me![beenprinted].Visible = False
End If
Case 5
If Me![beenprinted].Value = True Then
Me![beenprinted].Visible = True
Me![beenprinted].Value = False
Me![beenprinted].Visible = False
End If
Case 6
If Me![beenprinted].Value = True Then
Me![beenprinted].Visible = True
Me![beenprinted].Value = False
Me![beenprinted].Visible = False
End If
Case 7
If Me![beenprinted].Value = True Then
Me![beenprinted].Visible = True
Me![beenprinted].Value = False
Me![beenprinted].Visible = False
End If
End Select

Form_Load_Exit:
Exit Sub

Form_Load_Error:
MsgBox Err.Description
Resume Form_Load_Exit
End Sub
Thanks in advance!
FireDrake

"Nothing I say this day will teach me anything, so if I'm going to learn I have to do it by listening." -Larry King

Print A3 Report In A4 Size For Crystal Report
Hi, i do have a hugh report designed for A3 paper, how could i get it printed on an A4 size paper?
i.e. the overflown portion is printed on a second A4 paper.

any suggestion is appreciated

Print An A3 Report On A4 Paper For Crystal Report
Hi, i do have a hugh report designed for A3 paper, how could i get it printed on an A4 size paper?
i.e. the overflown portion is printed on a second A4 paper.

any suggestion is appreciated

Help Crystal Report Print Stock Report
I am using Visual Basic 6.0 and Crystal Reports 8.5 for my Stock project.
I would like to ask how to produce the following report :

Date     Invoice Item     Quantity Metric
--------------------------------------------
01-09-04 A     A001     1500 Kilogram
02-09-04 B     A001     100 Gram
     ----------------------------------
     Subtotal :        1 Ton
             500 Kilogram
             100 Gram
     ==================================

03-09-04 C     B001     20 Piece
     ----------------------------------
     Subtotal :         1 Dozen
             8 Piece
     ==================================

I already have these functions to convert the values :

Function ConvertToSmall(Item, Quantity, Metric)
     ConvertToSmall(1500100, grams) 'For Item A001
End Function

Function ConvertToLarge(Item, SmallQuantity)
     ConvertToLarge=Array(3,2) -> (1,Ton), (500,Kilogram), (100,Gram)
End Function

These functions can also be used for the B001 with
the metric conversion (Dozen, Piece, Gross) = (12,1,144) in which
1 Dozen = 12 Piece, 1 Gross = 12 x 12 = 144 Piece.

And does the 8.5 version support the bar-code printing?

I would really appreciate if anyone could help me.
thanks

Active Data Report / Print Directly To The Printer
-Anybody can give me an idea how to use VB6.0 ActiveData Report work or sample using a custom paper size. pls.

-Can I print directly to the printer w/o using 3rd party / Active DataReport like DOS base?

-What font will look like and fast as DOS base print out?

THANKS IN ADVANCE

Crystal Report To Default Printer
Dear all,

We are using VB60 and Crystal Report Control 4.6
How do we get de report "d: estq.rpt" to our default printer? A lot of people can reach the report and have there own default printer.

Nice regards,
Michelle.

CrystalReport1.ReportFileName = "d: estq.rpt"
CrystalReport1.PrinterName = "????"
CrystalReport1.Destination = crptToPrinter
CrystalReport1.MarginLeft = 1
CrystalReport1.Action = 1

Crystal Report On Dot Matirx Printer
Does anyone know of any reason why a crystal report would not display correctly (some lines showing very large and others show as just dots and dashes) on a dot matrix printer?

Printer Selection In Crystal Report 7
Dear Members
i am using crystal report 7
the problem is this that i have to select the printer From the user,kindly send me any solution.
Thanks

How To Specify Printer In Crystal Report 9.2 At Run Time
I am using CR 9.2 with VB 6

How do I specify printer in crystal report at run time. Addition My printers are local printer and share printer.

Printing A Crystal Report To Printer
So far I've just been printing my reports to a window, but now want to print to the printer.

I set my reportfilename and printfilename and set it to print to printer, but each time I want to print it, it asks me for an output filename. I enter it, but nothing gets printed - a file with the name I specified when asked is just created.

Any suggestions??

Andy

How To Select A Printer In VB Crystal Report.
Hi

How to select a printer in vb.

I have VB5, VB6 & Crystal Report.

My crystal reporter PRINT button Active only WINDOWS DEFAULT PRINTER.

Every time we are go to Control Panel - Printer Settings - select a printer & set as Default Printer.

I want choose the printer name in RUN Time.

I tried to Common Dialog aslo.

Is it possible ?

How to write the coding / settings.

By
IRAM

Crystal Report 9 Printer Queue Doc. Name
simply.... HELP!!!

I have been trying for weeks and months to figure out how to cutomize the printer queue document name when crystal report is printing out a report.

The default queue name is something like "Crystal Report ActiveX.." or similar.

Is there a way to fix/rename the Printer Queue document's name?

I'm totally lost on this. Any suggestions, pointers or hints are much appreciated. Thanx.

Selecting Printer Using Crystal Report In VB6
Hello,

I would be grateful if someone could help me to be able to select a printer whilst using crystal report 8 with Visual Basic 6.

Thanks

Changing Printer In A Crystal Report
I have designed serveral reports using Crystal Reports for my VB 6.0 application. When I run them within my application, when the report previews on the screen, I can click on the 'printer' button. The box which comes up then, does not give the user a chance to change the printer(all of our users have 3 printers to choose from). Is there a way for a user to select the printer without Crystal Reports overriding it? Thanks.

Crystal Report Printer Does Not Respond
Hi
I have a Crystal Report printing problem on the Network printer.
I am using CR 7.0

I have the following code Snippet:

CrystalReport1.ReportFileName = gReportsPath + "" + "Report1.RPT"
CrystalReport1.ReportFileName = gReportsPath + "" + "Report1.RPT"
......... bla bla bla
CrystalReport1.Destination = 1
CrystalReport1.Formulas(0) = " "
CrystalReport1.Formulas(0) = "Status = " + "'" + gsStatus1 + "'"
DoEvents

......... bla bla bla

The problem is

-- -- the report does not print or display from the VB code
-- -- it prints very well from the Crystal Report menu.
-- -- I even put the printer's IP address and name on the property of the CR Control in my VB code.

I appreciate any help or suggestion what might be wrong in my code or the report reference

Thank you very much.

abanik

Crystal Report Printer Setup
Hi
I have placed a Crystal Report Designer in my VB project and I have a crystal Report Viewer on one of my forms that shows the report. My question is how can I get the Printer Setup button to appear on the Crystal report viewer so the user can choose where to print their crystal report? Is this possible?
Thanks in advance

How To Enable Printer Icon In The Crystal Report
Hi all

I developed an vb appl with the crystal report.My system is not connected to the printer.So while working on the report it shows that no default printer is connected and printer is disabled.

But on my client side they connected to the printer. But the printer icon is disabled.

How is enable the printer icon in the report in my client side.

Please help me out.

Regards

Sasikumar

PROBLEM IN PRINTING A CRYSTAL REPORT TO PRINTER
MY REPORT PRINTS TO THE SCREEN BUT WHEN I PRESS THE PRINT BUTTON THE REPORT DOES NOT GO TO THE PRINTER . KINDLY HELP

Printer Icon In Crystal Report 10 (Crviewer)
i need help regarding CR10. how can i set the printer icon in CR10(CRviewer) where i can choose the type of printer and how to set the paper if it is landscape or portrait? kindly help...

Edited by - edd_hills on 4/29/2006 5:56:14 AM

Where Is Printer Setup In Crystal Report Viewer?
Dear all,

I was using Crystal Report Control in my VB Project to show my .rpt report files.
For some reasons, I'm using Crystal Report Viewer now.
But I can't find Print Setup button in it's properties, not like CR Control, I can enable it by setting WindowShowPrintSetupBtn properties value to True.
Is there any way to show Printer Setup Dialog in CR Viewer like in the CR Control? so I can choose which printer i'm going to use.

please share.

Crystal Report Printing Directly To Printer
hii iam trying to print report directly to printer iam using Crystalreport 8.5 and vb6
so can any one help me how to print directly iam using this code it executes but it wont print.

Me.CrystalReport1.ReportFileName = "I:Reportvbreport.rpt"
Me.CrystalReport1.DiscardSavedData = True
CrystalReport1.Destination = crptToPrinter
CrystalReport1.PrintReport

VB, Crystal Report , Acrobat Reader, Printer
Hello!

I would like print (manualy) acrobat reader document. I use crystal report vb code to generate the document. Everything allright.
But i would like change the printer default of the acrobat reader document generated (This document only)

How can i do?
Thank's
Gaël

Print Crystal Report..!
How can I print 2 copies of report per 1 page..?
Help me plz!
Thanks!

Crystal Report Do Not Print
Using Crystal Report 8.5

I have no problem printing on my program while I was testing it and even when I have package and setup to my pc. I setup to another computer and there are no error in Installation. Problem occur when I tried to print, the printer icon shows on system tray then suddenly gone. There were no error message but it did not print anything. Please see codes below.

CrystalReport1.Reset
CrystalReport1.Destination = crptToPrinter
CrystalReport1.DataFiles(0) = App.Path & "myDatabase.mdb"
CrystalReport1.Password = Chr(10) & "myPassword"
CrystalReport1.ReportFileName = App.Path & "myReport.rpt
CrystalReport1.DiscardSavedData = True
CrystalReport1.PrintFileType = crptCrystal
CrystalReport1.WindowState = crptMaximized
CrystalReport1.Action = 1

I guess it was only printing in my PC because I have Crystal Report. I’m also thinking that I might be needing some files or DLL’s of Crystal Report.

Any help will be highly appreciated.

Thanks

Print A Crystal Report From Vb
before i used crystal report
i had access report and printed it from vb withinh the prog with preview button on a form
is there a way to do this with crystal report
hope i have given enough info but newbie to this
cheers
Doug
this is the code i used

Code:Private Sub Command1_Click()
Const strLcREPORT_NAME As String = "race"
Const strLcFilePathName = "C:pigeonsirds.Mdb"
    Me.Command1.Enabled = False
Set udfMvAccess = New Access.Application
udfMvAccess.AutomationSecurity = 1
' Open Database
    udfMvAccess.OpenCurrentDatabase (strLcFilePathName)
    ' Open Report
    udfMvAccess.DoCmd.OpenReport strLcREPORT_NAME, acPreview
    ' Ensure Report Is Visible
    udfMvAccess.Visible = True
    Me.Command1.Enabled = True
End Sub

vb6 and access 2003
also newbie
may the force be with you

Edited by - dougvcd on 7/25/2005 11:01:12 AM

Best Way To Print With Crystal Report 8.5 + VB6
Good day,

This is my first post and hopefully some experts can solve my issue:

My friend is using Crystal Report 8.5 to create the reports (.rpt) and he is using Active Data Source (ADO) to select the records. E.g. Customer Information data from Table_Customer.

In my VB project, I will provide a customer information maintenance screen and a print button that allows the user to key in the customer code, read, update the information and print the amended record. I am using ADO connection and recordset to retrieve and update the records.

When I tried to Crystal Report component on my form, i found that I cannot use the ADO recordset as my Crystal Report Data Source. As I found another solution from the CR website and these are the codes that I am using :

    Dim CRXApplication As New Craxdrt.Application
    Dim CRXReport As Craxdrt.Report
    Dim CRXDatabase As Craxdrt.Database

    Set rsRecord = New ADODB.Recordset
    strSQL = "SELECT * from Customer where Cust_Id = " & "'" & txtCustID.text & "''
    Set rsRecord = cnADO.Execute(strSQL)

    Set CRXReport = CRXApplication.OpenReport(App.Path & "Customer.rpt", 1)
    Set CRXDatabase = CRXReport.Database

    CRXDatabase.SetDataSource rsRecord, 3, 1
    CRXReport.PaperSize = crPaperA4
    CRXReport.Database.SetDataSource rsRecord, 3, 1

    frmPrint.CRViewer1.ReportSource = CRXReport
    frmPrint.CRViewer1.ViewReport
    frmPrint.Show

My Questions :

1) There is no "Preview" option for CRXReport. I have to use the CRViewer in order for me to preview my report. Anybody know is there a setting/option to do that ?

2) How do I pass a text string to Crystal Report ? E.g. The customer is a guy then I will send "Mr. " else "Madam". Do I need to create a text object in Crystal Report ? What is the syntax to pass my string value to that particular text object.

3) This is a only a simple recordset and if I have a recordset that is selected from 2 tables then how do I pass the recordset to Crystal Report ?

May be the way that I am using now cannot be used to solve all the issues that I have faced. Is there a better way of doing these things ?

Many thanks,
Yang

Can Not Get A Crystal Report To Print
Can you think of any reason (beyond the obvious), as to why a Crystal Report that
works fine from the Crystal Reports Application(ver 4.6) refuses to print inside of a visual Basic
application(VB 5.0) using the PrintReport method?

I Used a line like this... CrystalReport1.PrintReport .... to attempt to print.

It "seems like it should be extremely straight forward and I've looked at many examples
and followed them without success.

Also, where can one get a newer versin of Crystal reports?

Thanks

What Is The Best Way To Print A Crystal Report
I am trying to print a report designed in crystal reports to print the contents of a database. I use the code

Private Sub cmdPrint_Click()

crReport.Action = crRunReport

End Sub

given in a book, but I get an error. Where am I going wrong and how do I rectify it

Crystal Reports Report Screen - Printer Not Working
Hi,

I have distributed runtimes for 8.5 onto a machine, because of poor quality images in reports, performed the various upgrades to my development machine and onto the server where i had installed the original runtimes, overwriting everything.

After some potching about because crystal reports refused to appear and then refused to export stuff, i got it all working - except, the printer icon is disabled and the printer-setup icon on a report does not do anything when you click on it (it allows you to click, but nothing appears).

I have run regmon and filemon to try and track any errors, but nothing appears out of the ordinary.

Any ideas which DLL controls connection to the printer etc.. ?

Thanks !