Hi, I have created a function that will accept multiple values for a parameter. I have added a textbox to the body where I want to display the values of the parameter but for some reason it only shows the first value. Why and how can I resolve it? Thanks...more >>

Hi Ppl I have alot of headache with pagination control on reporting services. Is there a way to control how many groups/items/rows in one page? Is there a way to show all items on 1 big page, instead of paging them? I've try to set the report hieght, but that doesn't help at all. If pagi...more >>

I have a report that is accessed by the users from a web page. The report is using the default report parameterss and not what is passed with the URL. No matter what is in the URL the report always render using the default report parameters. What could the problelm be?...more >>

Does anyone know of a trick to get the page count for the report into the report body? It seems to be limited to usage in the header/footer. I tried to create custom code function that assigned the page count to a parameter, and then displaying the parameter, but doesn't seem to work. Anyon...more >>

I'm creating interactive reports (= with parameters), deploy & run them, and then I can view them in the IExplorer while I'm choosing the appropriate parameters. If I'll give the URL of the report to one of the users he will not be able to run and view it in his IExplorer because he doesn't have...more >>

Hello... I've got a report... and based on a parameter to the report I'd like to include/exclude the column from appearing once you've run the report.. Example, by default report spits out aggregate data... if I can determine a specific parameter isnt blank, I'd like to hide a column, a...more >>

Hi All, I'm developing a parameterized report. The list of valid values is obtained via a SQL query that returns (ID, Description) pairs. The Description is presented in the parameter drop-down and the ID is passed to the SQL stored procedure when the report is run. The problem is that...more >>

I would like to reference a textbox name in an expression. When I write the following expression, I get an error saying that the textbox name is "private": =ReportItems!txtPatientName.Name Error: The value expression for the textbox ‘textbox1’ contains an error: [BC30390] 'Microso...more >>

PDF report has every other page blank. I don't know if this is a configuration problem or it's a bug. I hope it's not a bug. Please advice. Thanks ...more >>

I have an OLAP Cube that is being accessed by Reporting services reports with MDX syntax. I am successful so far in having one parameter set. I need to know if it is possible to have more than one to set and get the desired results accordingly. Here is what I have so far: Data Source: ="Select...more >>

I have a custom DPE that implements the IDataReader interface, setting the internal source data as a DataSet. The dataset contains a single table which could potentially contain 0 rows, depending upon the report parameters. My particular problem is with subreports. If the subreport's datase...more >>

Hello all, I have two parts in my report. Each part needs a diff set of parameters. Need a way to hide one of the 2 parts based on the parameters typed in (like if they type in A or B or C i need to hide ReportX and vice-versa if they type in D, E, F). Tried the table properties Visibility ...more >>

Has anyone been able to use impersonation with the Reportviewer control? We've tried and all we get is the clients credientials being returned with insuffiecient rights in the viewer control. The impersonation doesn't seem to be used at all. ...more >>

I have a current web farm cluster with two nodes. These servers have no domain controller, but are using local accounts to execute the report manager/report server. As well, both report servers are pointing to the same SRS database. When on either web server adding a new group or user thro...more >>

lHi, I have two date parameters (Start Date and End Date) in one report and it alows users input startdate and enddate. But I don't want users execute reports more than 5 days from the start date. How do I limit it before the reprot gets executed? Thanks. Chuck...more >>

Can I use a ADO dataset as a datasource for a report using Reporting Services 2000? Or will I have to implement a custom data extension. Does anyone know?...more >>

Hi, I have 2 questions: * How can I deploy my reports , as part of setup, to customer sites? I use VS.NET deployment and install Shield tools. * Can I break my reports into multiple HTML pages? Like search results, I would like to have multiple pages and use my own buttons to navigate betwe...more >>

Hi all Hoping someone can help me out. I'm new to reporting services and cannot quite seem to figure out what steps to take with the following. 1. Create reports on the fly... one of the problems I have is that I would like to alter the rdl file before it is displayed to the user so I can ...more >>

I have a Report Server where I have had to change the IP address of the server and to the remote database server. After the IP address change, I started receiving the following message when I access the report manager. The report server installation is not initialized. Check the documentatio...more >>

I'm on a deadline so any help would be much appreciated. I am building a Reporting Services report that takes a number of parameters with which to call a stored procedure. I am using the Microsoft OLEDB provider for Oracle. (For some reason, the Oracle OLEDB provider that I have manually insta...more >>

When is the next version of RS going to be released What changes have they made. ...more >>

I have configured the RS server for external web reporting. Obviously I only want to use SSL. The links on the toolbar(upper right) on the report manager do not point to the SSL pages so of course they do not work. I have made the changes to the RSWebApplication.config and RSreportServer...more >>

All, I have recently installed reporting services on a web farm. My question is this: Do I need to have any type of content replication between the servers? It appears that all of the report definitions etc. are stored in the SQL database. Nothing except for logs appears to be written ...more >>

Hello everyone, Does anyone have an idea when sp2 is comming out for RS? We have a Hot-Fix for a certain excel rendering issue but this fix is included in sp2. I just want to know if it's worth it to wait for sp2. -- Regards, Eric...more >>

I'm trying to get localized text in my reports. Therefore I created satellite assembly dll's with 2 languages. A test project (C# windows application) works fine, depending on the selected CultureInfo the correct language is shown. So I put this code in the report (exception handling removed) an...more >>

Hi all. I am succesfully catching divide by zero errors using IIF statements, all of the other expressions work fine except for this one below. The proc that feeds the report does return 0's if there is no data. As of now both fields have a value of zero, as time goes by there will be data. ...more >>

Hi , How can i avoid dispalying of "SubReports and datasource in ReportServer Browser" if any one have answer plz let me know Thanks...more >>

Hi, experts. I have a strange problem with accessing Analysis Services from Reporting Services. Our client needs to public reports in the web site and to make them accessible for everybody. In order to achieve it, I did the following: 1. In IIS I put the anonymous access for the virtu...more >>

I have seen all the other SSL related problems, and I don't think I am having the same issue...but I am having something similar. I have Reporting Services SP1 installed on the same machine as SQL Server. IIS is also on this machine. The machine is not part of a domain and its full name is S...more >>

Hello, I have a matrix report displaying data from a data cube, via analysis services. It contains column groupings for Months, Quarters and Year as well as row groups for Team, User and Region. This allows the user to drill down from a top level "All Teams" total for the whole year, down t...more >>

Hi, I am trying to deploy a new set of report to the Reporting server, but these new versions of the reports do not seem to appear in the Report Manager. There is no errors reported within VS.Net when deploying. Will it help to either restart the web server or restart the database server in o...more >>

Simple question - I have a date as a parameter. When I enter 12/1/2004 for example and run the report, after the data is displayed, the parameter displays "12/1/2004 12:00:00AM". Is there any way to pass the typical date format like "MM/dd/yyyy" to the parameter so that it formats the date o...more >>