Solved

open ssrs report with parameters from vb.net

Posted on 2014-09-08
2
430 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How do I figure out a “DependencyProperty.UserValue” exception in my WPF/MVVM application? 1 35
Reactjs with .NET 3 127
Adjust the codes 3 65
VB .net 2010 Byte array 2 24
In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

710 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