how to connect vb6 and crystal reports

[aashish_9601]

I have created an report(i.e sales invoice) in crystal report. I want an application in vb6 which enables user to enter the invoice number and open that particular invoice report(the invoice number is in the format eg. 1 1234)

[Pasvorto]

What version of CR?

[Hack]

Moved to reporting

[aashish_9601]

My Crystal Report Version is 8.5

[RobDog888]

This should help:
http://www.vbforums.com/showpost.php...89&postcount=2

[artstar]

Hello:
I am by no means an expert, however you should follow "Robdog888 link" and then you will want to create a (parameter field in the report itself) or pass the "Invoice #" thru a (Recordselection) with VB-Code so that you can print/view the correct invoice.

Example(((Report.RecordSelectionFormula = "{model.brandid}= " & DataCombo4.BoundText)))) this one is for a number field.

Example((Report.RecordSelectionFormula = "cdate({repairhistory.repairdate})>= " & Chr$(35) & dtp2 & Chr$(35) & " and cdate({repairhistory.repairdate})<= " & Chr$(35) & dtp3 & Chr$(35) & " and {repairhistory.technician}= " & Chr$(34) & DataCombo1.BoundText & Chr$(34)

this one is for a "Date field and a String field" (Chr$(35)=#) chr$(34)=" a date field has to be enclosed in #07/07/2007# a string has to be enclosed in "Joe's Bar".

I hope this helps.