.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Help Passing Multiple Parameters Via a URL in SSRS 2008

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Hello Everyone, I'm totally and completely confused as to how to pass multiple paramters through a URL.  Book Online is absolutely no help because they do not offer any examples of passing multiple paramters within a URL.  Instead, I get confused over RENDER and COMMAND and what should be repeated where with each paramter and on and on and on. Here's my URL: javascript:void(window.open('http://sereporting01.wdig.com/ReportServer?%2fDOL%2fTEST%2fDisney+Sell-Through&rs:Command=Render&SiteName=Disney,InsertionType=300 x 250,Context=ROS','_blank','resizable=yes,toolbar=0,menubar=0')) What happens is that JavaScript opens a new window but I get a "Reporting Services Error".  I'm assuming it's because my URL parameters are not correct.  Can someone please just give me the correct syntax so that I can get on with my work? I'm editing this post to add - I'm also confused as to how paramters are supposed to be passed through to a report when default paramters are set up in the report which i'm trying to open with the URL.  Should I remove the default paramaters from the report or...what? Again, BOL offers no help on this issue and it just seems to generate more questions.  Thanks!!  

View Complete Post

More Related Resource Links

Passing Multiple Parameters in NavigateURL Property of Hyperlink

In ASP.NET 3.5, is this the only way to pass Multiple Parameters in NavigateURL Property of Hyperlink ? What about using the HyperlinkField?<asp:TemplateField HeaderText="Form Name">    <ItemTemplate>        <asp:HyperLink ID="HyperLink2" runat="server"         NavigateUrl='<%# "~/Application/" + Eval("FormType") + ".aspx?FormID=" + Eval("FormID") %>'         Text='<%# Eval("FormName") %>'>                </asp:HyperLink>     </ItemTemplate></asp:TemplateField>

SSRS 2005 WebService Programatic Multiple Parameters?

I am using ssrs webservices with c#. Works great until I try to pass in multiple parameters then I get: "Default value or value provided for the report parameter 'X' is not a valid value." I am at a loss - I have the split function in my stored procedure and can pass in the values like '01/05/2010,01/062010' etc no problems. I have tried wrapping the comma seperated string with single quotes and without, tried adding them as seperate inputs with no luck same response. Report works fine from SSRS interface but not when calling it using web services. Any assistance is greatly appreciated - I have done numerous web searches and found no answers. Below is the c# code snipet: //set up the parameters List<ParameterValue> input = new List<ParameterValue>(); ParameterValue pval = new ParameterValue(); pval.Name = param.Name; pval.Value = "'" + paramsSelected + "'"; input.Add(pval); //call the report service.Render( ReportName, "PDF", null, null, input.ToArray(), null, null, out encoding, out mime, out outParams, out outWarn, out outStreams);

Passing parameters from ASP.Net web page to SSRS report

I have a web page that displays some data.  The user first selects a date range on the web page and then can edit some data.  When they click a submit button, I want to run a report.  But I would like to pass the start date and end date values that the user already entered on the web page to the report.  Is this possible?  Can I use the value of a session variable in the report? Bob

Problems passing parameters to SSRS report from ASP.Net web page

I have a web page that displays some data.   When they click a submit button, I want to run a report.  But I would like to pass the start year/month and end year/month values that the user already entered on the web page to the report.  Here is what my url looks like when the report is displayed: http://xyzserver/Reports/Pages/Report.aspx?ItemPath=%2fReports%2fDevicesAllNew&rs:Command=Render&StartYYMM=201007&EndYYMM=201008 But my report displays the 2 textboxes for my StartYYMM and EndYYMM parameters as empty.  What am I doing wrong?  I did a google search and I saw something about using ReportServer instead of ReportManager.  I notice at the top of the browser when I run my report, it reads "Report Manager - Windows Internet Explorer".  Is this correct? Bob     Bob

SSRS 2008 Help Setting Up Multiple URLs

I have a new SSRS 2008 installation that currently only has the default URL setup (http://computername:80/Reports).  I am trying to setup a second URL to be accessed by the intranet.  I want it to be a more generic name such as http://finance.  I have tried adding a second host name but when I do that it just says the page is not available.  What do I need to do in order to get this setup?  Do I need a registered domain name?  I have no clue where to start.

SSRS problem with passing multiple parameter values via URL %2c

Hi, I have a problem with passing multiple parameter values from one report (A) to another report (B).   For example I built a URL string in report (A) with the parameters like &Parameter1=1&Parameter1=2. As soon as I click on that URL the URL parameters look like &Parameter1=1%2c2 and the parameters don’t getting populated on report (B).   If I change the parameter in the URL to &Parameter1=1&Parameter1=2 and execute the URL manual the parameter on report (B) getting populated properly.   Is there a way to disable the coding like %2c (comma) or is there another solution for it?   Thanks

Passing multiple parameters

I want to be able to pass multiple parameters through DataNavigateUrlFormatString both th PONumber and ProjectCode. 
Could someone please help me?
<asp:DetailsView ID="DetailsView8" DataSourceID="AccessDatasource8" 
        runat="server" Height="50px" Width="125px" AutoGenerateRows="False" 
         <asp:HyperLinkField DataNavigateUrlFields="PONumber" 
                  DataTextField="PONumber" HeaderText="PONumber" 
                  NavigateUrl="~/bringPO.aspx" Target="_blank" />

              <asp:BoundField DataField="PONumber" HeaderText="PoNumber" 
                  SortExpression="PONumber" HtmlEncodeFormatString="True" />
                  <asp:BoundField DataField="ProjectCode" HeaderText="ProjectCode" 
                  SortExpression="ProjectCode"  HtmlEncodeForma

Problem Using Invoke and passing multiple byref parameters


I have code, shown below highly simplified that works all except for 1 thing: The variables being passed byRef get passed, but once modified in RecordData, they are never updated in the calling function. The calling function does not receive the updated data that is in the variables custid and amt. When debugging, I see the data in the else section of if me.invokerequired, but once it returns from the callback and is in the latter part of if me.invokerequired the data is missing.

How do I fix this?


Delegate Sub RecordDataCallback(ByRef custid As String, ByRef amt As Double)

Private Sub RecordData(ByRef custid As String, ByRef amt As Double)
    If Me.InvokeRequired Then

SSRS 2008: Multiple Sub-Reports with conditional visibility in one List control


MainReport: a List containing two Sub-Reports. The data of the List only has two rows. Set the visibility of the sub-report based on the data.

SubReport1: a textbox showing "Sub Report 1"

SubReport2: a textbox showing "Sub Report 2"

I expect to see SubReport1 in Page 1 and SubReport2 in Page 2.

But I only see SubReport1 in Page 1 and Page 2 is a blank page.

These reports work in SSRS 2005, but not in SSRS 2008.



Report Definition:



<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner

Multiple Parameters Error OLEDB MS Access SSRS



I have created an SSRS in BIDS 2008 with OLEDB Provider so as to access MS Access 2010 DB. My report is working fine. But the only problem is when am sending multiple parameter it raises error. I have enabled AllowMultiple Value checkbox.

ERROR : "Cannot add multi value parameter '@parametername" for DataSetName because it is not supported by the data extension".

My query is "SELECT * FROM tablename WHERE ([columnname] in (@parametername))"

Thanks in advance



Can't SSRS 2008 handle stored procedures which return multiple tables?


I tried it and it only returns the first table.

Any suggestion?

Thank you,


SSRS 2008 datetime parameters



I am trying to design a report that has a parameter named Time Period which, essentially, has the following available values: Last 24 hours, Last 7 days, Last Month, etc.  I have two other datetime parameters named Start Date and End Date which are going to specify the date ranges for which the report will select the data.

The Time period parameter is needed so that if the user specifies "Last Month", for example, the Start Date and End Date parameters automatically refresh to show the date ranges for the last month.  More so, the user can still be able to specify a different date range that they can pick from the calendar picker.

I have encountered several issues in trying to make this work:

  1. If I only specify a default value to the start date and end date parameters, it will only refresh for the initial run, but will not refresh every time I change the Time Period parameter selection.
  2. If I specify "Available Values" to the datetime parameters, then the parameter will turn into a dropdown field and the user will not be able to choose any date from the calendar picker.

I found a work around for this issue by creating an intermediate parameter and every time I change the time period option it will refresh the parameter since it has a stored procedure assigned

Can we show a line chart on multiple pages with page breaks? SSRS 2008


Hi there,

I am using SSRS 2008. I have a line chart which queries a huge dataset and shows the datapoints really close to each other that the labels and grid-lines are overlapping onto each other. http://oi54.tinypic.com/2vifrb9.jpg

Is there a way to split the chart and show it on different pages.? Thanks in Advance :)


SSRS 2008 - Subreport passing a value back to the main (master) report



Looking for a way to pass a calcuated value or Sum from a Subreport back to the Main Report.   Is there anyway to do this.  In past posts, with the most recent being 2008, it is said that this feature was not available or included in SSRS.

Using SSRS 2008.



Passing parameters between 2 SSRS reports deployed in report manager



I have created 2 reports in SSRS. In my 1st report there is a tablix, which contains many rows. The text in these rows act like hyperlink and upon click navigate to my 2nd report. This functionality is working fine in Visual Studio and also in report manager. But as soon as I deploy my reports in SharePoint site (using a page viewer web part), this functionality breaks. I can see when I take my mouse near the text in the Tablix it shows a URL like http://IP Address/Reportserver/

It's evident that the URL here is not forming correctly. Can anyone help me out in this issue. In my report for navigation purpose I had used Action -> Goto Report (report 2) and passing the parameters there.

Thanks in advance,


Data driven subscriptions need to use multiple "From" addresses - SSRS 2008


Is it possible to create a data driven subscription that supplies the from address based on which brand of my company is sending out the email? Or even if I'm representing a single brand, I need to use different email addresses such as customerservice or accounting or system.admin, etc. This cannot be a rare situation, what do all of you do to address this concern? Am I missing something obvious?



Multiple reports straight to pdf (SSRS 2008)

Hello, I have successfully written code to generate a server report straight to a pdf document. I did this using Report.Render(...) and then writing the result with Response.BinaryWrite. This works fine. The thing I would like to do now is this: On the webpage the user sees a tree with about 20-30 reports on it. I would like the user be able to select which reports he wants to see (using the tree check boxes) and then when he hits print one pdf document is generated with all the selected reports on it. Any suggestions? Thanks.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend