Set query dynamically

[bhaumikdv]

i want to change the report's query dynamically. means i want give input as query and then as per my query report should be set. i want to do same for the report's subreport. subreport;s query also i want to pass as main report parameter and den dat query should ne set in the subreport.

can any1 show me the way ?

[OuTCasT]

You can set string to textbox input on your form and then use the string to set the query for the report.

Dim query as string
query = txtQuery.text

Dim sqlCom as sqlcommand = new sqlCommand(txtQuery.text)

Something like that .

[OuTCasT]

Passing parameters to your report.

'\\ Code to send parameter through to Crystal Report //
        Dim frmReport As New Form2
 
        'Set parameter for report
        Dim oCR As New SinglePayslipTest
 
        'Give parameter oCR a value
        oCR.DataDefinition.FormulaFields.Item("UBWONo").Text = "'" & strPayslipSingle & "'"
        Dim s As String
        s = oCR.DataDefinition.FormulaFields.Item("UBWONo").Text = "'" & strPayslipSingle & "'"
 
        'Set sqlCommand for report
        Dim sqlCOm As SqlCommand = New SqlCommand("select * from earnings where employeeid = '" & s & "'", sqlCon)
        Dim DA As New SqlDataAdapter(sqlCOm)
        sqlCon.Open()
        Dim DS As New DataSet
        Dim DT As DataTable
        DA.Fill(DS, "EmployeeID")
        DT = DS.Tables(0)
        oCR.SetDataSource(DS)
 
        'Set report source of Viewer to oCR
        Form2.CrystalReportViewer1.ReportSource = oCR
 
        'Log on information for Crystal Reports
        logOnInfo = oCR.Database.Tables(0).LogOnInfo
        logOnInfo.ConnectionInfo.ServerName = strOldServerName
        logOnInfo.ConnectionInfo.DatabaseName = strCompanyName
        oCR.Database.Tables(0).ApplyLogOnInfo(logOnInfo)
        sqlCon.Close()