[RESOLVED] To pass parameter from vb6 to crystal report

[damini_dd]

Hello Friends,

My problem is I want to accept value from user which I am nt storing in databasse. I am using inputbox to get value from user and then I want to print the same value in the crystal report. I am not using crystal report viewer, but I've used crstyal report's ocx and from there i am opening report by using printreport method of the crystal report's ocx control. plz help me.

below is my code which i m using to print report

With crStudList
        .Connect = strConn
        .ReportFileName = App.Path & "\reports\StudentList.rpt"
        .ReportTitle = "Student List"
        .WindowTitle = "Student List"
        '.SelectionFormula = "{tblStudent.RegistrationDate}>= DateValue (" & dtpFrom.Value & ") and {tblStudent.RegistrationDate}<= DateValue(" & dtpTo.Value & ")"
        .SelectionFormula = "{tblStudent.RegistrationDate}>=#" & Format(dStartDate, "dd/MM/yyyy") & "# and {tblStudent.RegistrationDate}<=#" & dEndDate & "#"
                .Destination = crptToPrinter
        .PrintReport
 
    End With

where crStudList the name of ocx control of crystal report

thanks

[Hack]

Moved to reporting section

[oh1mie]

Selection formula is like SQL clause.
If you like to pass argument to the report, you must build formula for it.

.Formulas(0) = "Myformula=' " & "my information line" & "'"

[damini_dd]

Hi oh1mie

Thax a lot. It solved my problem

thax again

[ezzy85]

I wanted to do something similar to what youre doing, but I dont know how to use vb with crystal. What do I need to get started? I dont have a crystl32.ocx file. Im using VB 2005 Express edition and CR 11.

[damini_dd]

I've not used vb 2005 express edition and cr 11

[Tribo]

I recommend vs.net 2003 with cr 9.