Creating reports and dashboards | Stimulsoft community forum

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

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:
Thank you.

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

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

Thank you.