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

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

SSRS 2005 WebService Programatic Multiple Parameters?

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :Sql Server
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);

View Complete Post

More Related Resource Links

Help Passing Multiple Parameters Via a URL in SSRS 2008

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!!  

Issue with Enable and Disable Parameters in SSRS 2005

Hi Guys, I am currently facing an issue with Enabling and Disabling Parameters in SSRS 2005. Here is my scenario. I am having the following 4 parameters - ParamType (has values 1,2,3), ParamMonth, ParamStartDate, ParamEndDate Now What I want is When I select ParamType = 1 and 2 then ParamMonth should be enabled and ParamStartDate and ParamEndDate should be disabled. When I select ParamType = 3 then ParamStartDate and ParamEndDate should be enabled and ParamMonth should be disabled. I have done google search on this issue and found out that this is not possible at run time. Is there any alternative for this issue? If the above is not possible, I would like to get atleast in this way : When I select ParamType = 1 and 2 then ParamMonth should show the values (from dataset named MonthDataSet and default should be the latest Month) and ParamStartDate and ParamEndDate should show as NULL. When I select ParamType = 3, then I need to enter ParamStartDate and ParamEndDate values manually or pick via datepicker and ParamMOnth should show as NULL. I am not sure whether this is possible or not....but just trying to get in some way. Here is the query used in MonthDataSet : Select Month_Code, Month_Name from MonthTable. Thanks

Multi Value Parameters in SSRS 2005

Hi Guys, I am having a parameter 'Employee' and it is multi valued. This parameter gets values from Dataset 'Emp_Data'. It has the follwing query: Select Employee_Code, Employee_Name from Employee_Table. I tried to do this but didnt get What I exactly want. What I have done is : IN the Report Prameters tab, went to Default Values section and selected From Query option and given the dataset name as 'Emp_Data' and Value Field as Employee_Code. Now When I view it in the Preview tab. I am getting as this in the Parameter Employee text box: Employee - James, Ross, Steve, Mark, Kevin........ For some reason, the client did not like this and they wants to see default as ALL Employees (instead of all those names displayed in the text box). So Is there a way to make it as ALL Employees as default (when all employees are selected). Note : I tried in this method also : Select 'ALL' as Employee_Code, 'All Employees' as Employee_Name                                         Union                                  

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



Separate Date and Time report parameters in SSRS 2005



Is it possible to declare separate report parameters in SSRS 2005 as Date and Time?

I want the user to be able to enter a date and a time.

When I declare the parameters in my stored procedure as datetime, in SSRS the parameter just shows as a Date only.


SSRS 2005 reports - Parameters slow to take input from user

I have SSRS 2005 reports with two parameters, StartDate and EndDate. When I run the report in the internet explorer, the report takes 30 to 40 seconds to respond to the user control. I mean the calendar picker appears only if I click after 30-40 seconds from the time the report loaded. I'd appreciate your thoughts to resolve this issue.


SSRS 2005: ReportServer: Listen on Multiple Domains and ReportBuilder 1.0


I recently upgraded to Windows 7 - and joined my workstations to our production domain.

I have 2 SSRS 2005 environments: one for test and one for prod. 

The prod SSRS instance is joined to the same domain as my workstation (ie. production.domain)

However, my SSRs 2005 test instance is joined to a test domain (i.e. test.domain)

i have my SSRS ReportServer configured to use "Integrated Authentication"  In Production, this works great.

In test environment, when I launch reportbuilder, ReportBuilder automatically detects my workstation domain (production.domain) so when it loads and tries to connect to TEST envrionemtn, it tells me I have no access.

The only way to make it work seems to go to my Test Environment server and add my production.domain\USERID to the Administrators Group.  However, i can't do this for every ReporBuilder 1.0 user.

Can ReportBuilder 1.0 or ReportServer SSRS 2005 be configured to listen and authenticate against two domains? my production and test ones?


Is Conditional Subscription possible in SSRS 2005?


Hi Guys,

Is there a way to set up a subscription that will send e-mails based on the contents of a report? For example, I want to schedule a daily subscription that will only send an e-mail if the report contains data, otherwise it will do nothing for that day. i.e If the report has more than one row, it should send the mail otherwise it should not send the mail.....

Is it possible in SSRS 2005 or is there any other way to do it???


SSRS 2005 "Mixed" Authentication Mode


I have a web application where users can authenticate using either SiteMinder or Windows domain accounts.  This is actually configured as two separate virtual directories within IIS 6.  Both applications need to use the same instance of SSRS.  Is it possible to configure the SSRS web application so that if a user is authenticated by SiteMinder it impersonates a Windows account, but if they are already Windows-authenticated that account is used instead?

Report printing problem(ssrs 2005)

HI   i have a SSRS 2005 report with width as 32 inches i have a requirement to print the report in a3 landscape  but when i print the report it comes in 3 page width   is there any way to auto scale the report into a3 size without affecting the view in the report viewer   Thanks varun kumar

ssrs recursive parameters

What are recursive parameters in ssrs?

Multiple XML files into SQL SERVER Express 2005

Hello. I am familiar with classic ASP and use this with MS SQL SERVER EXPRESS. I have an SQL table and want to import multiple XML files into this on a daily basis. I currently have 3 files, transferdata.vbs which loops through the XML files. FAQschema.xml which maps XML to the SQL database and test.xml shows the xml in the test file. If I run transferdata.vbs I get the following error "Error opening the data file" line 33 char 3. Microsoft Bulkload for SQL Server". My SQL table is called EnqOrd id (int), Debitor (varchar), PurchaseDate (varchar)     transferdata.vbs set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad") objBL.ConnectionString = "Provider=SQLOLEDB; Data Source=XXXXXX\XXXXX; Initial Catalog=XXXX; User ID=XXXXX; Password=XXXXXX" objBL.ErrorLogFile = "E:\fuelsql\Teccom\error.log" ' Here is the path to your XML files Const path = "E:\fuelsql\Teccom\XML\" Dim Text, Title, oFile Dim fso, oFolder, oFiles, wsh ' Object variables Text = "Folder " Title = "XML Files" Set wsh = WScript.CreateObject("WScript.Shell") ' Create FileSystemObject object to access the file system. Set fso = CreateObject("Scripting.FileSystemObject") ' Get Folder object. Set oFolder = fso.GetFolder(wsh.ExpandEnvironmentStrings(path)) ' Get All Files Set oFiles = oFolder.

ssrs 2005 default value generates report

Hi, If all parameters have default value the report generates as soon as i load the report. Is it possible to only run the report when clicking on the view report button even if all parameters have default values? Thanks

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>

Question regarding IIF statement and Grouping in SSRS 2005

Hi Guys, I am using SSRS 2005. I am facing small prob in using IIF statement to hide a column. I am having a Grouping in my table. (Emp_Group and the values are 'Yes' and 'No') Now, I want to hide a column of the table if Grouping is Yes and I want to show the table if Grouping is No. (When exported to excel it will appear in two different sheets). Any suggestions please............

SSRS 2005 external images won't display - images on DIFFERENT file server

Hi, Been having trouble getting external images to display in reports rendered on SSRS 2005. Images are displayed as a red X. However, my scenario is different from some of the examples I have read about. - The images are stored on a file server that is DIFFERENT from the box on which the Report Service is running. For various business reasons I cannot copy the images locally to the Report Service box. I am using "file://fileserver/path/to/image.jpg" to retrieve the images. - Since the file server does not have IIS installed, I cannot access the images using the URL method (http:// access). I need to use the file:// method. Currently I am prototyping this setup on my test box, which is running XP Pro and IIS 5.1. The Report Service is installed on this same box. I am currently testing this through the Report Manager web site (http://servername/Reports). The images are displayed using the Image control, which I added to the report using the visual report designer in Visual Studio 2005. It is set up with source=External and with "file://fileserver/path/to/image.jpg" path values. File names are retrieved from our database and file paths are built dynamically using a data processing extension I have written. My best guess as to why this is happening is that the ASPNET service account on my test box does not have access to the particular share on the file serve

Shared dataset in SSRS 2008 R2 running on SSAS 2005

I am trying to create a report in SSRS 2008 R2 using SSAS 2005 as a datasource. My dataset has a date parameter. When I create an embedded dataset in my report everything works fine, but when I create a shared dataset with the exact same mdx query, I get the following error: An error occurred during local report processing. The definition of the report 'xxxx' is invalid. The Value expression for the report parameter 'DateCalendarHierarchy' contains an error: [BC30034] Bracketed identifier is missing closing ']'. Does anybody have any ideas? Is this a bug? Thanks, Louis
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