Results 1 to 2 of 2

Thread: parameters passed, but not getting picked up as variable in select expert

  1. #1

    Thread Starter
    New Member
    Join Date
    Jan 2006
    Posts
    12

    Angry 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"

  2. #2

    Thread Starter
    New Member
    Join Date
    Jan 2006
    Posts
    12

    Re: parameters passed, but not getting picked up as variable in select expert

    This has been solved. Thanks

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