Need Help: Problem with sql parameters

[putputty]

I use ASP.NET 2005.

I have problem of showing report in WebReportViewer when I use parameters in sql query

select * from Employee Where DepartmentNo=@DeptNo

and in asp.net file

Protected Sub ddlPosition_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlPosition.SelectedIndexChanged

Dim Report As Stimulsoft.Report.StiReport = New Stimulsoft.Report.StiReport()
Report.CompiledReport.DataSources.Item("Employee").Parameters.Item("@DeptNo").ParameterValue = ddlPosition.SelectedItem
Report.Render()
StiWebViewer1.Report = Report

End Sub

I think my code in vb is wrong. Can someone please help me? I'm very new to Stimulsoft program

[Vital]

I have problem of showing report in WebReportViewer when I use parameters in sql query

select * from Employee Where DepartmentNo=@DeptNo

and in asp.net file

Protected Sub ddlPosition_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlPosition.SelectedIndexChanged

Dim Report As Stimulsoft.Report.StiReport = New Stimulsoft.Report.StiReport()
Report.CompiledReport.DataSources.Item("Employee").Parameters.Item("@DeptNo").ParameterValue = ddlPosition.SelectedItem
Report.Render()
StiWebViewer1.Report = Report

End Sub

I think my code in vb is wrong. Can someone please help me? I'm very new to Stimulsoft program

Please use following code:

Code: Select all

        Dim Report As Stimulsoft.Report.StiReport = New Stimulsoft.Report.StiReport()
        Report.Load("FileOfYourReport.mrt")'You need load any report to Report object
        Report.Compile()'You need compile report before use Report.CompiledReport
        Report.CompiledReport.DataSources.Item("Employee").Parameters.Item("@DeptNo").ParameterValue = ddlPosition.SelectedItem
        Report.Render()
        StiWebViewer1.Report = Report

Thank you.

[putputty]

Dim Report As Stimulsoft.Report.StiReport = New Stimulsoft.Report.StiReport()
Report.Load("./App_Data\TestDB1.mrt") 'You need load any report to Report object
Report.Compile() 'You need compile report before use Report.CompiledReport
Report.CompiledReport.DataSources.Item("Connection").Parameters.Item("@ValueID").ParameterValue = ddlPosition.SelectedItem
Report.Render()
StiWebViewer1.Report = Report

I still get error in the red line code with System.NullReferenceException error

[Vital]

Please send us your report. After examine your report we can say you what you need change.

Thank you.