How I pass parameters to SSRS Report from CodeBehind in VB.Aspx project.

Aypn CNN 446

Hi,

Pls, help me to share your ideas with some samples on passing parameters to SSRS, I'm unable to get results when passing parameter values from Code Behind.

ref my below code; Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init

    If Not Page.IsPostBack Then

        AttendanceId = Request.QueryString("_RecordId")

        ReportViewer1.ProcessingMode = ProcessingMode.Remote

        Dim serverReport As ServerReport
        serverReport = ReportViewer1.ServerReport

        serverReport.ReportServerUrl = New Uri("http://00.0.0.0:00/Reports/")
        serverReport.ReportPath = "/f_SSRS/StudentAttendanceReport"

        Dim parameter As New ReportParameter()
        Parameter.Name = "@i_AttendanceId"
        Parameter.Values.Add(AttendanceId)

        Set the report parameters for the report  
        Dim parameters() As ReportParameter = {parameter}
        serverReport.SetParameters(parameters)
        Dim parameters As List(Of ReportParameter) = New List(Of ReportParameter)
        parameters.Add(New ReportParameter("AttendanceId", AttendanceId))
        ReportViewer1.ServerReport.SetParameters(parameters)
        ReportViewer1.LocalReport.SetParameters(parameters)
    End If

Lan Huang-MSFT 25,551 Reputation points Microsoft Vendor

2021-10-11T10:00:00.75+00:00

Hi @Aypn CNN ,

I'm unable to get results when passing parameter values from Code Behind.

Maybe you can provide specific error information, so that we can better help you solve the problem.
Best regards,
Lan Huang
Aypn CNN 446 Reputation points

2021-11-19T14:42:50.163+00:00

Hi,
Sorry for the delayed response, I want to pass parameters from VB code Behind to SSRS, pls share few examples on this.

Thanks in advance.

Lan Huang-MSFT 25,551 Microsoft Vendor

Hi @Aypn CNN ,
You can refer to the following code:

    ReportViewer1.ServerReport.ReportServerUrl = New System.Uri("http://MyPC/reportserver")  
    ReportViewer1.ServerReport.ReportPath = "/ReportFolder/Reportname"  
    Dim Param As Microsoft.Reporting.WebForms.ReportParameter() = New Microsoft.Reporting.WebForms.ReportParameter(3) {}  
    Param(2) = New Microsoft.Reporting.WebForms.ReportParameter("SDATE", "02/02/2002")  
    Param(1) = New Microsoft.Reporting.WebForms.ReportParameter("EDATE", "09/06/2000")  
    Param(0) = New Microsoft.Reporting.WebForms.ReportParameter("TASK", 0)  
    View.ReportViewer.ShowParameterPrompts = False  
    View.ReportViewer.ServerReport.SetParameters(Param)  
    View.ReportViewer.ServerReport.Refresh()

Best regards,
Lan Huang