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)
Printable View
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)
What version of CR?
Moved to reporting
My Crystal Report Version is 8.5
This should help:
http://www.vbforums.com/showpost.php...89&postcount=2
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.