🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.lang.basic.visual.database
Article #33

Crystal Report Control for vb6 app

#33
From: Corey Harbaugh
Date: Fri, 17 Nov 2000 04:09
27 lines
2352 bytes
I have a simple DAO app.  I want to use the crystal report control for a
custom report that I made for this app.  It's the client report.  When the
client creates a new record I want them to be able to print just the current
record.

I have a menu to print the report here is the code for the click event.

Dim ID as Byte
ID = txtWorkOrderID.Text        'this is the primary id for the table, its
also displayed as locked textbox on the client form.
PrtCurrent.DataSource = "ctsworkorder.mdb"        'this is the database,
PrtCurrentRecord is the name of the Crystal Report Control
PrtCurrent.SelectionFormula = "woMain.WorkOrderID" & ID "         'woMain is
the table, WorkOrderID is the primary id for the table
PrtCurrent.PrintReport            ' print to screen


I get nothing from this code, the control doesent even open!  What am i
doing wrong?  I have the report name in the Crystal Report Contol propertys.


Help ME!


Thanks,

Corey
Technical Details
Message-ID: <Rb2R5.65$7.99512@typhoon.kc.rr.com>
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!logbridge.uoregon.edu!newsxfer.eecs.umich.edu!cyclone.rdc-detw.rr.com!news.mw.mediaone.net!cyclone.kc.rr.com!news.kc.rr.com!cyclone3.kc.rr.com!news3.kc.rr.com!typhoon.kc.rr.com.POSTED!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 110e3b,e921512243c01fd0,start
X-Google-Attributes: gid110e3b,public
X-Google-Thread: 11629a,e921512243c01fd0,start
X-Google-Attributes: gid11629a,public
X-Google-Thread: 1143a7,e921512243c01fd0,start
X-Google-Attributes: gid1143a7,public
X-Google-Thread: 108062,e921512243c01fd0,start
X-Google-Attributes: gid108062,public
X-Google-ArrivalTime: 2000-11-16 20:09:22 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!logbridge.uoregon.edu!newsxfer.eecs.umich.edu!cyclone.rdc-detw.rr.com!news.mw.mediaone.net!cyclone.kc.rr.com!news.kc.rr.com!cyclone3.kc.rr.com!news3.kc.rr.com!typhoon.kc.rr.com.POSTED!not-for-mail
From: "Corey Harbaugh" <charbaugh1000@hotmail.com>
Newsgroups: comp.lang.basic.visual.database,comp.lang.basic.visual.misc,comp.lang.clipper.visual-objects,cz.comp.lang.basic.visual
Subject: Crystal Report Control for vb6 app
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <Rb2R5.65$7.99512@typhoon.kc.rr.com>
Date: Fri, 17 Nov 2000 04:09:21 GMT
NNTP-Posting-Host: 24.166.168.161
X-Complaints-To: abuse@rr.com
X-Trace: typhoon.kc.rr.com 974434161 24.166.168.161 (Thu, 16 Nov 2000 22:09:21 CST)
NNTP-Posting-Date: Thu, 16 Nov 2000 22:09:21 CST