hi,

   i have problem in passing parameter to the report.
i have added an existing report to my project which accepts parameter.
when i run this aspx page though i get the specified report but, i able to get desired output. I mean report get dispalyed only in the perivious saved format only no change even after passing the parameter.


plz help me out and tell me how to pass parameter to the crystal report through asp.net form


plz help me!
waiting desperately for the reply.

thanks in advance.

Hi

I use dataset to do this:
        'open sql con
        strQuery = strQuery & strWhere 'setup the query with constratints
        sqlDA.SelectCommand.CommandText = strQuery
        Dim sqlDS As New DataSet
        sqlDA.Fill(sqlDS)
        Me.cvReport.Visible = True
        newRpt.SetDataSource(sqlDS.Tables(0))
        cvReport.ReportSource = newRpt
        sqlCon.Close()

hope it helps.

hi,

Thank u very much for ur timely help.

well, i tried out other method which worked fine.
here is the code...........

Dim cityvalue As String
        cityvalue = Request.QueryString("city")
        hidcity.Value = cityvalue


        ' Binding by report object.
        'CRobj is a report object either u can pass the path or pass the class
        'testorganization_para() is the automatically generated class of report.

        Dim CRobj As New ReportDocument()
        Dim CRdiscretevalue As New CrystalDecisions.Shared.ParameterDiscreteValue()
        Dim CRParameterFieldDefinitions As ParameterFieldDefinitions
        Dim CRParameterFieldLocation As ParameterFieldDefinition
        Dim CRparametervalues As New CrystalDecisions.Shared.ParameterValues()

        ' Get report parameter's collection

        CRobj = New testorganization_para()
        faccrystalreport.ReportSource = CRobj ' faccrystalreport is a crystalreportviewer
        CRParameterFieldDefinitions = CRobj.DataDefinition.ParameterFields
        CRParameterFieldLocation = CRParameterFieldDefinitions.Item("organization city")
        CRparametervalues = CRParameterFieldLocation.CurrentValues

        Dim CRParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue()
        CRParameterDiscreteValue.Value = cityvalue
        CRparametervalues.Add(CRParameterDiscreteValue)
        CRParameterFieldLocation.ApplyCurrentValues(CRpara metervalues)
        '
        ' Set the Crytal Report Viewer control's source to the report document.
        '

        faccrystalreport.ReportSource = CRobj

        'connection string and table information declaration

        Dim tablelongoninfo As New CrystalDecisions.Shared.TableLogOnInfo()
        Dim con As New CrystalDecisions.Shared.ConnectionInfo()

        Dim CRdatabase As Database
        Dim CRtable As Tables
        Dim cretable As Table

        con.ServerName = ""
        con.DatabaseName = ""
        con.UserID = "sa"
        con.Password = ""
        CRdatabase = CRobj.Database
        CRtable = CRdatabase.Tables

        For Each cretable In CRtable

            tablelongoninfo = cretable.LogOnInfo
            tablelongoninfo.ConnectionInfo = con
            cretable.ApplyLogOnInfo(tablelongoninfo)

        Next

        faccrystalreport.ReportSource = CRobj
        faccrystalreport.DisplayToolbar = False
'---------------------------------------------------------------------

This code is working fine.

can any one plz tell me what i have to do to pass more than one parameter(20r 4 parameters).

thank u very much.