parameters passed, but not getting picked up as variable in select expert
Hi,
I need to use 2 parameter fields in order to select a range of date values. I am able to pass the values to the report fine, but when using the selection expert i use the variables as below and Crystal doesn't want to use them.
Am i passing them wrong. See code below.
THanks
raistlin
CODE IN VB
-----------
Dim ParameterFields As CrystalDecisions.Shared.ParameterFields
Dim ParameterField1 As CrystalDecisions.Shared.ParameterField
Dim ParameterField2 As CrystalDecisions.Shared.ParameterField
Dim ParameterField1Value As CrystalDecisions.Shared.ParameterDiscreteValue
Dim ParameterField2Value As CrystalDecisions.Shared.ParameterDiscreteValue
Dim MyReport1 As New CrystalReport1()
Form2.CrystalReportViewer1.ReportSource = "C:\Documents and Settings\administrator\My Documents\Visual Studio 2005\Projects\WC\WC\crystalreport1.rpt"
ParameterFields = Form2.CrystalReportViewer1.ParameterFieldInfo
ParameterField1 = ParameterFields("fromdate")
ParameterField2 = ParameterFields("todate")
ParameterField1Value = New CrystalDecisions.Shared.ParameterDiscreteValue
ParameterField2Value = New CrystalDecisions.Shared.ParameterDiscreteValue
ParameterField1Value.Value = txtFrom.Text
ParameterField2Value.Value = txtTo.Text
ParameterField1.CurrentValues.Add(ParameterField1Value)
ParameterField2.CurrentValues.Add(ParameterField2Value)
Form2.CrystalReportViewer1.ParameterFieldInfo = ParameterFields
Form2.CrystalReportViewer1.Refresh()
CODE IN CRYSTAL
-----------------
{CALENDAR.DUEDATE} >= cdate({?fromdate}) and
{CALENDAR.DUEDATE} <= cdate({?todate}) and
not ({CALENDAR.WHAT} like "F/U") and
{PAGE0.TYPELAW} = 10 and
{CALENDAR.TYPE} = "DEP" OR
{CALENDAR.TYPE} = "CUTOFF" OR
{CALENDAR.TYPE} = "19B" OR
{CALENDAR.TYPE} = "19B1" OR
{CALENDAR.TYPE} = "TRIAL" OR
{CALENDAR.TYPE} = "MOTION" OR
{CALENDAR.TYPE} = "SOL" OR
{CALENDAR.TYPE} = "STATUS" OR
{CALENDAR.TYPE} = "HEARING" OR
{CALENDAR.TYPE} = "MEETING"
Re: parameters passed, but not getting picked up as variable in select expert
This has been solved. Thanks