Visual Basic :: Label Printing In Crystal Reports?

Printing Label Without Using Crystal Report
hi there,

I'm having problem with assigning values to print out labels (for use of greeting seasons), I have to select records from 2 tables -- tblClient & tblDependent. The 2 tables match each other using clients' name.

tblClient DOB (mm) tblDependent DOB (mm)
Andy 04 Annie 04
Bobby 04 Barby 08

refer to eg above:

I need to print out all the addresses of those whose birthday falls on the same month. The addresses are stored inside tblClient. If I choose Month(DOB) = 08, my problem is how would I print out Barby's name with Bobby's address?

* My label is 2 col x 7 rows = 14 addresses in a A4 size page

Please advice...Thanx in advance...

Printing Reports From VB 6 Using Crystal Reports
I have delveloped an application for invoice generation and printing.
I have 2 tables(MS ACCESS), first will store invoice details and the second will store item details of invoice like serial no, description, qty, rate and value.
for a given invoice there will be 4-5 items.

In the crystal report(ver 7), I have linked first table containing invoice details with the second table containing invoice item details.

The item details are printed in the detail structure part of crystal report.

The problem is when I print the report, the report generates individual invoice for each item rather than one invoice for all the items.

I wish someone could rectify this error and enable me to implement the software

Regards

NSNRao

Printing Crystal Reports From VB 6.0
I am currently working on program in visual basisc 6.0. and I want to print some already created crystal reports from within vb. However, I don't want that when I select the print command button the report opens up to be displayed. I would like for it just to be printed. I have tried the object.printReport code but it does not work at all. I am using the following code:

CrystalReport1.ReportSource = crptReport
CrystalReport1.ReportFileName = "C:Program FilesVacationLeave.rpt"
CrystalReport1.Destination = crptToPrinter
CrystalReport1.Action = 1

When this code is executed I get an error stating "Unable to load Report."
Does anyone have an idea how I can do this? I response will be greatly appreciated.

Nisean

Crystal Reports Printing
Hi,

I am writing a vb interface to allow the users to select a report from a file list box and then print it.

The problem I seem to have at the moment is the fact that the reports do not print out, either through some vb code or the crystal reports viewer print button. I get the printer dialog box up and click "OK" but then nothing happens.

CODE:

Dim application As New CRAXDRT.application
Dim Report As CRAXDRT.Report
Dim selectedreport As String

selectedreport = File1.Path & "" & File1
Set Report = application.OpenReport(selectedreport)
frmrptviewer.CRViewer91.ReportSource = Report
frmrptviewer.CRViewer91.ViewReport
Report.PrintOut True, 1, False, 1, 1

Does anyone have ideas?????

Slim

Crystal Reports V9 Printing....
Based on certain criteria, I need to either print one or two pages.

Ex:

Code:
If rs1("AEIOU") = Trim(UCase("y")) Then

Report = "TEST.rpt"
Report01 = "P2_TEST.rpt"

PrintView

Else

Report = "TEST.rpt"
PrintView

End If
How would I do this? Thanks...

PrintView looks similar to this...

Code:
Public Sub PrintView()

Set CRReport = crApp.OpenReport(ReportPath & Report)

CRReport.ReadRecords

'other stuff

End Sub

Crystal Reports Printing
This is the first time I used the crystal reports 8.5 viewer object, I see it has a print button on it, I looks great and all, but now how do you get it to actually print the report. Here is my code for opening the report.

Code:
CRViewer1.EnableGroupTree = False
CRViewer1.Visible = True
Me.MousePointer = vbHourglass

Set report = cRepApp.OpenReport(reportPath, 1)

CRViewer1.ReportSource = report
CRViewer1.ViewReport

Set report = Nothing
Set cRepApp = Nothing
Me.MousePointer = vbDefault

Printing With Crystal Reports
Printing with crystal reports
I have built a form to initiate printing results from crystal reports
(form attached)
how to I use the print command to send the report to the printer from the form.
Hope someone can help..

Crystal Reports Printing.
I have my Crystal reposrt object printing fine.. EXCEPT that annoying 4-line page prints after the report prints. How do I stop this from printing? (It's the one that lists user, host, class, etc...).

Printing In Crystal Reports
how can i use the print command dialog box available in VB 6.0 to print crystal reports ??

i want the flexibity at run time to change the printer and also send reports via fax or e-mail them . or is there any other way out to do the same

VB, Crystal Reports And Printing
Hi,

I am developing a VB application that will call Crystal Reports.

Is there a way to determine if a user that is previewing a report in Crystal has chosen to print that report from the preview screen ?

I could set up 2 separate buttons from VB, one that runs a preview report and one that just prints the report, but would like to see if there is some type of return code that can be checked.

The report will be sent to a network printer.

Thanks for any feedback.

Printing With Crystal Reports
I need help with printing a Crystal Report.

I want to use the Common Dialog to select the destination printer, but using PrinterDefault=True the selected printer becomes default one.
If I don't use it the Crystal prints in default printer.

How can i print in other printer without changing the default one using Common Dialog.

Thanks in advance.

Crystal Reports Not Printing
I have an application that uses the Crystal Reports included with Visual Studio 6.0 to create and print the reports.
My problem is that on about 1 out of 5 boxes, that the app gets installed onto, the printouts won't print. I don't know why this is occuring. I think that there is something missing on the boxes that don't print, but I don't know what it is. Is there a reference, a dll or another file that I need to include?

DOS Printing Using Crystal Reports
Hello,
I want to use Draft/Dos printing using crystal Reports 8.0 using VB6. Can some one guide me how to do Draft printing using Crystal Report

Thanks in Advance

Regards Amit
Amit

Need Help For DOS Printing Using Crystal Reports
hello sumit,
you give the code for DOS printing using crystal reports
but tell me one thing
which reference is to be set for this
bcoz crystalreport1.reset and all other properties not work in crystel 8.5
then how u use this property
and tell me where to write this code
i write theis code on the CRViewer1_PrintButtonClicked event
it is right or not
thnx in advanve
wait for ur replay
naren

Printing Crystal Reports
Hi,

I have created a crystal report to gather data and print when equal to a specific ID, and I want to call this report from vb and make it print the report using the ID I have open on my application.

So is there a command like this in existence?

call printreport(thereport.rpt, id=123)

Thanks

VB6 Printing To PDF Or Using Crystal Reports 7/9
Hi,

I've previously posted here about a problem that I had with printing 15461 HTML statements. I've now been informed by the printing company that I need to export to PDF which they say is more reliable, or use Crytal reports 7 or 9.

Lastly, is it possible while using Crystal, to export to PDF

To be honest, I've never exported to PDF or used Crystal.

Can anyone can tell me how to integrate either of or a combination of these two?

Thanks

Edited by - Tigga on 2/11/2004 6:15:23 AM

Crystal Reports / Printing
Hi guys.

Im in a bit of a fiddle - any help on the following would be appreciated.

Ive set up a small order application for a Computing project in college. At the moment I have everything working fine apart from the print function. My initial idea was to print the form "as is". Instead I was instructed to use Crystal Reports.

- shortcut -

Ive set up my order table so I can view invoices depending on orders but at the moment when I go to the form created by Crystal within my VB6 project, I can only view/print all records.

Ideally what I want to do is have a button on my order screen with 'Print Invoice for this record' button on there. However, i have no idea how to do this as Ive been using Crystal for literally 6 hours.

I would appreciate anything you can give me - even if its to tell me how dumb I am for not realising how easy it was.

Thanks for your time

JG

Jamie Gooden
jamie.gooden@ntlworld.com

VB6 / Printing With Crystal Reports
Hi there,

I am using Crystal Reports 8.5.
Accessing MS Access Database.

I have written a small program to display the data from access through crystal to the user.
The program works like a charm on the my development machine. ( Have VB6 and Crystal Fully installed )

When I package and deploy the program the following happens : ( No VB6 and Crystal Fully installed )
Have vb run time files.
Have crystal DLL'S needed to run the stuff I think all of them. Registered them too.
Got the stuff from their notes...... if only,OCX is used they say use the following dll's:
crystl32.dll
mfcans32.dll
olepro32.dll
crpe32.dll
crpaig80.dll
implode.dll
mfc42.dll
msvcirt.dll
msvcp60.dll

Vb program runs no problem but when report selected to be displayed the crystal reports window opens up and immediately closed down (not displaying the report ). It does not crash the VB program.

In my VB code I have added a Crystl32.OCX only.

The code that is in my program to display the report "on development machine" is as follows ( and it works ):

*************************************
Connection to the Access Database Code :

Public cn as ADODB.CONNECTION
Set cn = new ADODB.CONNECTION

With cn
.connectionstring = " Provider = Microsoft.Jet.4.0;Data Source=c:Database.mdb"
.open
end with
*************************************

To display the report
*************************************
Private sub cmdCommand1_Click

%ReportName% .DataFiles(0) = "c:Database.mdb"
%ReportName%.ReportFileName = app.path & " %Name of the Crystal Report.rtp%"
%ReportName%.RetrieveDataFiles
%ReportName%.PrintReport
end sub
*************************************
When i looked at the event log generated by crystal --- it said something like "%Name of the Crystal Report.rtp%" database could not be found (something along those lines).

I have already established the connection, and I know that works ..... so how come crystal does not see it???
Am I missing something ???
Is my SET LOCATION in crystal right ...... it looks something like this "TableName!c:Database.mdb" ????
Am i missing any DLL'S ???
When I refresh the data in the crystal report design mode it gets all the relevant records from the database.
Help will be greatly appreciated .....
Thank You.

Printing In Crystal Reports 4.6
I am using crystal reports 4.6 to print info from my database which is in Access 97. There are some fields that are not required to be filled in thus could be left blank. My problem is that if the field is blank I do not want to print it. Each of these fields are 50 characters long so I can only print 1 field per line & I do not want/need a bunch of blank lines on the page. I tried creating a formula in crystal reports checking the length of the field but I am missing something. All the examples show either numeric formulas or IF-THEN-ELSE type comparisons. I created a formula named chkblank using the following: length(trimright({MAINTF.MAINTDES1}))>0

Then I inserted the formula CHKBLANK onto my report. When I do that it puts TRUE or FALSE on my report not the actual data in the field. Anybody no what I am missing here?

thanks!!
Kathy

Printing Crystal Reports Vb6
how to give crystal report in vb6 to print certain no of records .

i have 1000 reports but iam providing the user to select how many he wants to print by using text box and a command button.

so when he enter 100 and press command button it should print only 100 records from those 1000 records and i have to update the Table field Printed = Y where Printed = NULL.

Any idea how to handle print report in vb6

Crystal Reports Printing
I have an unique problem.
Ihave done a project for shopping mall.
I am printing bill for the items purchased by the customer.when i give print command,
it prints as i want.
problem is
It should stop after printing the last line of the report as they are using paper roll
If the report is of 3 pages,it prints correctly(only if 3 pages are full)
else if 3rd page is half then the rest of the page gets ejcted which i dont want.this is not predefined size .
If u still want further clarification I can give u.

this a challenge for cr/vb programmers

plz help me in this

Printing ADO Crystal Reports
For some reason none of the Crystal Reporst I generate using ADO will print at all. If I try to print the report manually using the CRViewer1.PrintReport method it blows up and tells me that "The control is busy downloading data." Is there anyway I can stop this? HELP ME PLEASE!!!

Printing Crystal Reports From VB
Silly question for someone:

In my VB6 Prof. program, I am automating the printing of a Crystal Report. None of the users will have a licensed copy, so I need to have it print without actually opening Crystal. Do I have to use the compiled (EXE) report or when I get it to print through my coding, it won't need to open the report? Am I making sense?

So far, when I've tested this on one of the users PCs it gave me a 'crystl32.ocx isn't properly registered or is missing' message. I copied that file to the required directory, but to no avail. Could this be cause by a newer version of Crystal being used (users have been using version5; I have version 7)?

If you can help in any way, I appreciate it. Thanks everyone and have a great day!

Wendy

Crystal Reports Printing From VB
Hi -
Does anyone know how to have VB code continue on after a Crystal Report was printed using the CrystalReport.1 Action = 1 ? Seems my program will wait for the printer to go thru it's communications and when I print 5 or 6 reports in a row, this makes the user wait until the VB program can continue. THanks in advanced.
Also, is there a way to close up "White space" in a crystal report if certain strings, are empty?
Ex- I have to print the contents of certain chemical blends and have Contents1, Contents2, ...(as database fields)If the latter ones are empty, I would like to close up that space. Is this possible? ALSO THanks for suggestions

Printing Crystal Reports From VB
Hi all,
Got a question for you. I've got my app built on VB 5 and am using Crystal Reports 6 to build my report. I would like to know how do I send my report to the printer using the standard Crystal Report OCX.
I'm using this code to call out the Printer Selection dialog,
CrystalReport1.PrinterSelect

This works fine but whenever I press the "Cancel" button, the report is printed anyway. Any suggestions??

10q
=)

The VB Bugs in my Life...

Printing Crystal Reports
I have generated various cross tab reportswith charts. Now, I need to print report and chart on separate pages. How can I do that?

One way to do this is delete the chart and print- you get the report alone. suppress the text fields and grid- you can print the chart alone.

This way, the chart does'nt look good. I want the chart to get in full page.

Any ideas gladly welcome

thanks

Crystal Reports Printing.
Is there a way that we can manipulate the printer so that we can choose which printer we want and to choose the advanced options durring run-time?

I tried the No printer option but the is right when the report pops up and it does not look good.

Also, I am creating the reports in the main Crystal Reports area, not in VB.

John-

Crystal Reports Printing Landscape
In my vb project I am using crystal reports as my report writer.

When I print my landscape reports out, they are printed out as portrait.

My vb project uses crystal report control

how could I fix this?

Thanks

he9ap00

Crystal Reports Column Printing
Hi! I am new to crystal reports. I would really appreciate if someone guides me how can i print records from database in columns. I want the records to be printed in 2 columns on the paper.

Crystal Reports Printing - Properties
I open the crystal report with the data loaded using a VB program.
For some reason it selects the option "Pages" instead of "All"
I want it to select "All" as default, anyone know how to do this?
thank you,
: y0use

Conditional Printing Using Crystal Reports
Crystal Reports XI - Developers Edition

I have a report that uses 2 MS Access Tables. They are:
PartStatus
dbPartNumber text 30
dbPartDescription text 50
dbIsThisNonInv text 1

InventoryNotes
dbPartNumber text 30
dbPartNotes text 250

In the Detail section I have a Record formula that states: {PartStatus.dbIsThisNonInv}="N" (This is working)

I am trying to print a list of all Parts(dbPartNumber) and there Descriptions(dbPartDescription) and dbPartNotes if there are any.

What's happening is ONLY those Parts that have dbPartNotes are printing.

In my test data, there are approximately 500 parts that are in the PartStatus Table where dbIsThisNonInv="N". In the InventoryNotes table, I have 3 Parts that have dbPartNotes. My output report should be a list of 500 Parts where 3 of them have notes. WHAT I AM GETTING is only the 3 Parts that have Notes.

In Crystal Reports, Under the "Database Expert" menu item, I have linked the PartStatus table and the InventoryNotes table via dbPartNumber..

Can you help me and tell me what I am doing wrong?

Thank you,
Sam

Crystal Reports 10.0 Not Printing With Windows XP
I am using Crystal Reports 10.0 (upgrade-Developer's edition) integrated with a Visual Basic 6.0 (SP5) application. The VB application is installed on Windows NT, Windows 2000, and Windows XP platforms and the reports print on all of these platforms except Windows XP. Any idea why???????

Crystal Reports - String Value Not Printing
yes I know, wrong forum but I'm getting no feed back from the Reports forum.

I'm reading data into a crystal report from an MS Access query via ODBC connection. The query has a MEMO field that is trimmed to appear as a text field. When trying to read this field into Crystal the field is blank and the length of the string is zero. The query displays the field fine, so why won't it import into Crystal OK? Once I remove the Trim() function it displays OK. There was no problem using this same query in v8.5 Prof.

Printing Arrays With Crystal Reports
I am wondering if anyone has found an easy way to print arrays in Crystal Reports? I'd appreciate any advice on this subject.

Printing Speed Like DOS From Crystal Reports
I want to have printing speed as we get from DOS Based applications
I am using VB + Crystal Reports for my application
But clients requirement for printing is they want speedy printing same as dos based envirement
Pls suggest any way...
its urgent
thanks

Problem Printing Crystal Reports
I am attempting to print a Crystal Report 8 report for the first time

I have created the Crystal Report using an Access 97 parameter query. I have setup the database as an ODBC data source and am using a Crystal Report Control in my program (ocx).

The code I am using to print is:

CrystalReport1.ReportFileName = App.Path & "ReportName.rpt"
CrystalReport1.PrintReport

An Enter Parameter window appears so I know the Data source is set up correctly and when I press Ok I get a preview window which appears and disappears very fast (although the control is set to preview in window) ....... and then nothing. It doesn't print OR bring up any error message!

Can anyone suggest what I am doing wrong or is there another way of attaining hte same result? Using the CRViewer component instead?

Can anyone Help me. Much appreciated!
Thanks

Printing To Any Printer In Crystal Reports
Hello,

I have a question about printing in Crystal Reports.
When you apply the Print-button in the report viewer, the document
is automatically send to the default-printer.
Is there a possibility (a setting in Crystal Reports?) to show a list of all the printers to the user, so he can choose which printer to print on.

Greetings, Ulricke

Crystal Reports And Clour Printing
I am trying to print a report using Crystal Reports. I have a color logop
in the report, but when I print is always prints in black and white only.
Any sduggestions?
Regards
Phil Jones
The Logical Interface
02 9541 0367
www.logint.com.au
email@removed

Crystal Reports 5 Not Printing On A Network
Hi,
I am programming in VB6 and using crystal reports 5 as reporting tool. I have developed a multi user software for one of my clients. The program runs fine on all the machines but the reports just dont come on the screen on all the terminals except the server. The OS in Windows xp.

Please help

Regards

Sanjish

Crystal Reports Printing Query
I just posted a query on VBCity forums sometime back regarding simlar kinda question but it worked partly so ask all u VB gurus out there to lend me a hand. Its like- i have crystal report which gets its data depending upon a particular SQL query which i pass onto it at runtime. this seems to work fine. now at runtime what my report diplays i want to print out three copies of it. well that'd be real simple but the problem lies in the fact that i want 'Original' printed on top of the first one, 'Duplucate' on top of the second one and 'Triplicate' on the third one. so heres what i did. I placed a text field on top of the report and changed its text in a loop. During runtime the first report turns out okay and prints okay as well but when the loop increments to 2 VB gives an error and exits. so the rest of the arent printed. Have look at my code:

    rptA5.Database.SetDataSource adoRecordset 'The recordset is populated by a SQL Query

    Dim X
    For X = 1 To 3                 'For 3 Copies
        Select Case X
        Case 1:
            rptA5.Text8.SetText "Original"
        Case 2:
            rptA5.Text9.SetText "Duplicate"
        Case 3:
            rptA5.Text8.SetText "Triplicate"
        End Select
    CRViewer1.ReportSource = rptA5         'You know what these two lines mean
    CRViewer1.ViewReport
    rptA5.PrintOut False             'Directly print to printer without any dialog boxes
    Next

It would be a great help it someone could make a quick example and post it herte

Crystal Reports Printing Problems
I'm trying to print a report through a VB.Net application in landscape using Crystal Reports 8.5 to HP LaserJet 4200. However, the report is always printing out as Portriat. I've changed the printer settings in the .Rpt file to Landscape, But the report is still printing out as Portriat instead of Landscape. The report prints fine if I print it out of a Lexmark Printer. The issue seems to be with the HP Printer. Please Help...........................

Edited by - FredSmithJr on 6/3/2003 9:14:39 AM

Crystal Reports - Printing A Calendar...
I'm using Crystal Reports 8.5 and I want to make a report that prints a calendar. My database is of pregnant mothers and each has an expected delivery date. I want to make a calendar that prints the name of the mother that's expected to deliver that day. Any ideas??

Mariano

Printing Crystal Reports In Vb6 W/out Using Veiwer
Hi,

I have a crystal report in my project that is saved as a dsr. This is my first time using crystal reports. I want to print the report when the user clicks on a command button. How do I do this?

I often feel I am parked diagonally in a parallel universe

Crystal Reports Duplex Printing
Hi there,

Some reports embedded in a VB 6.0 SP5 on Win2K project are printed on both sides of paper and some not. I really can't find how to enable/disable this feature.

There should be a checkbox to specify duplex printing but where ?

The report is called roughly like this :

------------------------------------------------------------------------------
Dim f As New frmCrystalReport

DFCatalogue.Database.Tables.Item(1).Location = prmDataBase
DFCatalogue.RecordSelectionFormula = Trim(SelectFormula)

f.Caption = "Catalogue"
f.CRViewer1.ReportSource = DFCatalogue
f.Show 1

Exit Sub

------------------------------------------------------------------------------

Thanks if you have infos about this

Problems Printing Crystal Reports
Hi all
we have developed a application which uses vb6.0,SQL server 7.0 and crystal report 7.0, When i try to print a CRViewer report i cannot print that report.I have set up a printer on my PC and it prints the reports which are made from crystal report control.Please reply as soon as possible
Thanks

Printing On DOT MATRIX With Crystal Reports
Hi all,
Im having trouble printing from my VB app using crystal reports.
The app runs on systems having 2000,NT and 98.....I have used the generic printer driver in Crystal Reports.
The problem is the formatting is fine on prints from 2000 systems,but the same report gets screwed up if a print is fired from NT or 98 clients....

Jacob

Help, Text Printing In Crystal Reports
We have a application in vb 5.0 and crystal 7.0. in our country a lot of people are still using dot matrix printers. It is very time consuming to print the report generated from crystal report. Usually this report is in graphics format and takes ages to print. In our application typically reports are of more than 200 pages. A viable solution is to convert the graphical output of crystal report to text format and print it to the dot matrix printer. This will increase the speed of printing. Using the normal export method of crystal report prints text in unformatted (unaligned ) format, which is not readable. Please suggest a way to send a properly aligned output to printer in text/DOS format.