Results 1 to 2 of 2

Thread: send Parameters to crystal reports from vb6

  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 2006
    Posts
    2

    send Parameters to crystal reports from vb6

    hello
    i want to send values to the parameters in crystal reports 9 from vb,can any one help me with the code.
    i tried the following code:
    VB Code:
    1. Dim Report As ais_billreport
    2. Dim PARAM As CRAXDRT.ParameterFieldDefinition
    3. Dim PARAMS As CRAXDRT.ParameterFieldDefinitions
    4.  
    5. Set Report = New ais_billreport
    6. '        Report.Database.Tables(1).SetLogOnInfo "", "aiswaria.mdb", "", ""
    7. '        Set PARAMS = Report.ParameterFields
    8. '        For Each PARAM In PARAMS
    9. '        With PARAM
    10. '            Select Case .ParameterFieldName
    11. '                Case "frmbillno"
    12. '                    .SetCurrentValue FROMBILLNO
    13. '                Case "tobillno"
    14. '                    .SetCurrentValue TOBILLNO
    15. '                End Select
    16. '        End With
    17. '        Next
    18. '        frm_report.CRViewer91.ReportSource = Report
    \\\\\\\\\\\
    i get error in
    Set PARAMS = Report.ParameterFields
    plse help me
    Thanks in advance
    Last edited by Hack; Jun 20th, 2006 at 09:15 AM. Reason: Added [vbcode] [/vbcode] tags for more clarity.

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: send Parameters to crystal reports from vb6

    Moved to reporting section

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