Solved

open ssrs report with parameters from vb.net

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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Get Client IP on RDS - VB.NET 15 48
Not seen Link button 5 41
Call Controller Action Method from ASPX 2 17
VB.NET 2008 - SQL Timeout 9 25
Flash (http://en.wikipedia.org/wiki/Adobe_Flash) has evolved over the years to where it has become a masterful tool for displaying content screen.  It has excellent layout placement, UI precision as well as rendering capabilities. This, along with t…
Summary Displaying images in RichTextBox is a common requirement with limited solutions available. Pasting through clipboard or embedding into RTF content only support static images.  This article describes how to insert Windows control objects int…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

831 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