|
-
Aug 30th, 2006, 01:15 AM
#1
Thread Starter
Fanatic Member
Cr9/vb6
Hi
I have a VB6 form that adds/Edit/Delete records from an Access Database.
Inside this form I have a Report button that generates a Crystal report related to only the current record.
The code is
VB Code:
Dim objCrystalApp As CRAXDRT.Application
Dim oReport As CRAXDRT.Report
rs2.Open "Select * from Btest where Flag=1 and BID=" & nar, cn, adOpenKeyset, adLockPessimistic
rs2.Close
Cancel = True
Set objCrystalApp = New CRAXDRT.Application
ReportPath = "C:\Book2\report4.rpt"
Set oReport = objCrystalApp.OpenReport(ReportPath, 1)
oReport.RecordSelectionFormula = "{Btest.BID} =" & nar
frmreport.crvMyCRViewer.ReportSource = oReport
frmreport.crvMyCRViewer.ViewReport
frmreport.crvMyCRViewer.Refresh
frmreport.Show 1
End If
my problem is that I have a checkbox whose caption is "Amended",if it is checked I want to add the word Amended inside a shaded Border into the generated report, if it is not checked i want to only generate the report.
how can I do it?
I am using Crystal Report 9
thanks
-
Aug 30th, 2006, 08:39 AM
#2
Re: Cr9/vb6
In CR.NET its easy because each report has a collection of objects you can browse and modifiy them easily.
Jorge
"The dark side clouds everything. Impossible to see the future is."
-
Aug 30th, 2006, 12:30 PM
#3
Thread Starter
Fanatic Member
Re: Cr9/vb6
Asgorath so what should I do in my case?
i am using CR9 and VB6 with Access database
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|