Solved

open ssrs report with parameters from vb.net

Posted on 2014-09-08
2
472 Views
Last Modified: 2014-09-11
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
Comment
Question by:MartinChadderton
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 10

Accepted Solution

by:
FamousMortimer earned 500 total points
ID: 40312078
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
 
LVL 27

Expert Comment

by:planocz
ID: 40313100
0

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question