VB6 and Crystal reports

[Rob3161]

I want to print a invoice from my access database using a crystal report. i have crystal report ready for that but dont know how to pass record selection criteria from my VB application to crystal report. It shows all record from invoice table. my ADO recordset in Vb application is rsInv with single record i want to print.

[Pasvorto]

What level of CR are you using?

[Rob3161]

I M using Crystal report 8, VB6 And Access Database

[Pasvorto]

I could give you some sample code if you were using CR9. It has been too long since I upgraded from 8. I don't have any VB6/CR8 code around anymore. The coding changed between the 2 versions. Sorry.

[mutley]

Try to use TTX

[Rob3161]

I am quite new to this , so please can you explain me what is that TTX?

[Rob3161]

For the same report in data report i am using

strSQL = "select * from inv1 where invno='" & cboInvNo.Text & "'"
rsInv.Open strSQL, cnnInv, adOpenKeyset
If rsInv.EOF And rsInv.BOF Then
MsgBox "Invoice No Not Found !!!!!!"
rsInv.Close
Exit Sub
End If

Set DEVat.rscmdInv1.DataSource = rsInv
DRInvFP.Show
rsInv.Close

where DEVat is dataenvironment and DRInvFP is Data Report

[Hack]

Moved to reporting section