open ssrs report with parameters from vb.net

I am trying without success to open my ssrs 2005 report from vb.net and pass in the parameter of which project needs to be shown in the report.

I am using the below code:

Response.Redirect("http://trustreports/Reports/Pages/Report.aspx?ItemPath=%2fTRANSFORMATION%2fQualityandEquality%2fStrategic+Objectives+Quality+Impact+Assessment&rs:Command=Render&ProjectRefno=4136", False)

where i have defaulted the project 4136 to test.

It opens the report fine but does not pass in the parameter.
LVL 1
MartinChaddertonAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
FamousMortimerConnect With a Mentor Commented:
Hi,

See this question: http://www.experts-exchange.com/Programming/Languages/.NET/Q_28498849.html

            Dim myReportParams(1) As ReportParameter
            myReportParams(0) = New ReportParameter("myParameterID", "ML2zsidjf99")
            myReportParams(1) = New ReportParameter("anotherParam", "YourValueHere")
            Me.ReportViewer1.ServerReport.SetParameters(myReportParams)

Open in new window

0
All Courses

From novice to tech pro — start learning today.