Results 1 to 4 of 4

Thread: Passing parameter values in VB6 using CR9

  1. #1

    Thread Starter
    New Member
    Join Date
    Jul 2008
    Posts
    2

    Passing parameter values in VB6 using CR9

    Hi all,

    I am VB6 as front end. I was earlier using CR8 and was able to effortlessly connect my Crystal Report using parameters as per code below.
    I used to put a CR ocx file in the form and define the Crystal Report name. This was so simple.

    I have now migrated to CR9. I want to know the code to be used for opening the report created earlier in CR8 which now works with CR9; but is not opening in the VB Application.

    Thanks,

    Surya


    The Code I used with CR8 was as under:

    With CrystalReport1

    .ReportFileName = "c:\pet-bill.rpt"
    .ParameterFields(0) = "STDT;" & "DATE(" & Format(CDate(sJoin), "YYYY") & "," & Format(CDate(sJoin), "MM") & "," & Format(CDate(sJoin), "DD") & ")" & ";true"
    .ParameterFields(1) = "endt;" & "DATE(" & Format(CDate(sJoin1), "YYYY") & "," & Format(CDate(sJoin1), "MM") & "," & Format(CDate(sJoin1), "DD") & ")" & ";true"
    .RetrieveDataFiles
    .Action = 1
    End With

  2. #2
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: Passing parameter values in VB6 using CR9

    AFAIK the .OCX is not supported by Crystal Reports 9
    You should use RDC

  3. #3

    Thread Starter
    New Member
    Join Date
    Jul 2008
    Posts
    2

    Re: Passing parameter values in VB6 using CR9

    Can you please guide me to use RDC step wise please?
    Regards,
    Surya

  4. #4
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: Passing parameter values in VB6 using CR9

    I hope that you find the solution in the attachment
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width