Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 553
  • Last Modified:

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.
0
MartinChadderton
Asked:
MartinChadderton
1 Solution
 
FamousMortimerCommented:
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

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now