asked on

VB.net Crystal Reports Multiple Parameters

Hello Experts,

I am trying to pass multiple parameters to the Crystal Report Viewer. Here is my code...

        Dim cryRpt As New ReportDocument
        Dim crParameterFieldDefinitions As ParameterFieldDefinitions
        Dim crParameterFieldDefinition As ParameterFieldDefinition
        Dim crParameterValues As New ParameterValues
        Dim crParameterDiscreteValue As New ParameterDiscreteValue

        cryRpt.Load(Application.StartupPath & "\Reports\SQLTipPool.rpt")

        crParameterDiscreteValue.Value = ("2015-05-10")
        crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields
        crParameterFieldDefinition = crParameterFieldDefinitions.Item("StartDate")
        crParameterValues = crParameterFieldDefinition.CurrentValues

        crParameterDiscreteValue.Value = ("2015-05-13")
        crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields
        crParameterFieldDefinition = crParameterFieldDefinitions.Item("EndDate")
        crParameterValues = crParameterFieldDefinition.CurrentValues

        crParameterValues.Clear()
        crParameterValues.Add(crParameterDiscreteValue)
        crParameterFieldDefinition.ApplyCurrentValues(crParameterValues)

        frm_ReportViewer.Show()
        frm_ReportViewer.CrystalReportViewer1.ReportSource = cryRpt

cryRpt.SetDatabaseLogon("dba", "pass", "sqlbase", "")

Open in new window

It wont pass the first parameter. At run time of the report, it asks me to supply it. Help?

Mike McCracken

Try putting # # around the date or pass a real date datatype. You are passing a string to a date it won't work. Crystal will not do a conversion.

mlmcc

triphen

ASKER

I should mention that only the first parameter has a problem. The second one passes just fine and it's in the exact same format. I believe it has to do with my VB.net code.

ASKER CERTIFIED SOLUTION

triphen

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

triphen

ASKER

I figured it out. See my last post.