Can anybody suggest the easy way to add an optional parameter to the report? Example: Without this "feature" the report contains records for the groups A, B, C, etc. I'd like to add the parameter "SingleGroup". By default it is null and the report should work exactly as before. If I set the v...more >>

I have a windows application which displays a remote report using the reportviewer. It works fine except on the form load it runs the report. I rather the report just display instead of running. This is a problem for two reasons: 1. My report has parameters. Since no parameters have been ...more >>

New ssrs istall. When I attempt to open report manager, i just get SQL Server Reporting Services Home with no option for creating a folder etc, like i have on development When I attempt to deploy to ther server I get : Deploying to http://amsqlclusterxx/reportserver/ Error rsItemAlr...more >>

I use Microsoft Visual Studio 2005 to write my reports. When I run the reports in VS it takes forever to run. I checkec the task manager and the System Idle Process is 70% while the reports are being processed. Question: Does anyone else have this problem? Does Microsoft Visual Studio 200...more >>

Is there a way to change the subreport name while running a report. Depending on the user that runs the main report i would like to present another subreport. The subreportname can't be changed by an expression. I could place all subreports on it and then hide the ones that arn't needed but...more >>

Please help - I am trying to deploy report on the server - getting following: =================================== A connection could not be made to the report server http://169.35.137.96/ReportServer/. (Microsoft Report Designer) =================================== The server committ...more >>

Hi, I'm using Reporting Services 2005, trying to design a report in Visual Studio 2005. I have a chart in the report that seems to work just fine when I test it with Preview. However, every now and then, if I change some trivial detail in the chart properties, such as the title font, ...more >>

Does Microsoft keep a previous version of the .rdl if you deploy a report in Visual studio 2003? If so, how do you retrieve it? ...more >>

Hello evry one, Can any one help me how to add a calender as a list of values,to an user parameter in reports. I am passing a parameter called effective date. for that parameter i need calender as a list of value. Please any one help on this.. thanks Balaji ...more >>

I am creating a very simple report in VS 2005. I dragged an image control to the report surface and set it's value property to the virtual path of my image (like "~/SubPage/Trademark.jpg"). However, the image is never displayed - either at design time, when the report viewer runs, or when the ...more >>

My machine is in a domain. The local group Administrators had a member that is the Domain Admins. Our Tech Support has configured this like that. Now, in the Home directory i've deleted the BUILTIN\Administrators from the users and groups that can access the tree. Even on some directories i'v...more >>

SQL Server 2005 reporting service is being used to generate a large excel report with about 30,000 rows. The size of file generated is ~15MB. but if the same file is opened in Excel 2003 and saved back in XLS format itself, the size of the file reduces to approximately 50% of the original size...more >>

Hello there, I'm currently experiencing some issues with Reporting Services' ReportViewer Control. When running the control without a Reporting Server in 'Local' processing mode we cannot serve very many simultaneous requests. Worse, if a single user opens several reports one after the oth...more >>

have a report that in the designer in Visual Studio it displays correctly on the preview tab. The report has 5 subreports and one of the subreports is a matrix. On the report I have a parameter for the user to choose rather to see the matrix subreport or not. When I view the rep...more >>

I have a very simple report that allows users to extract data to an excel spreadsheet and work with it. It consists of a single matrix with 3 row groups, 1 column group and 1 "fact" cell. When it is run, either in preview or deploy mode, the report is hiding duplicate values in the first colum...more >>

I have the dataset with the following tables, Products and OrderDetails. The structure (simplified): CREATE TABLE [dbo].[OrderDetails] ( [Id] [int] NOT NULL , [ProductId] [int] NOT NULL , [Quantity] [numeric](18, 2) NOT NULL , [Price] [numeric](18, 2) NOT NULL ) ON [PRIMARY] GO CREATE T...more >>

I need to build a report in which every field of the dataset acts as a Parameter to filter data in the report, so that the user is not binded only to a fixed set of filters. Based on the datatype of the filter; the condition should be specified and the user will only supply the value for which...more >>

Dear All, We are facing some issue in reporting service subscriptions. In one of the server when We create subscription to save or send report, Its giving below error. But reports works fine directly from the report manager. ERROR: Failure sending mail: An error has occurred during r...more >>

duh I know. I'm on the reportserver as administrator. I'm looking sql mgt studio and iis, I know reports and folders are there somewhere, but can't see them. Thanks for any help or information. ...more >>

I am making change to a report and believe I am correctly deploying it to an ssrs report folder per the messages I get back from vs.net. Question is, how can I see what folders are available? and where? At some point I knew or was able to do this, and think it was through SQL server since I ca...more >>

Hi, Does anyone know how I can limit SS report access only through our application? Thanks. SSRS Standard Edition ...more >>

I have an XML field (of type XML) in my report's underlying table. I want to display a hyperlink in my report. When the user clicks on this hyperlink, I want them to be able to save the xml value as an XML file on disk (i.e. "Save File As" in MSIE). Has anyone tried this? Thank you, --...more >>

Hello. I've got an odd requirement to password a particular report.Basically the same authenticated user will have access to all reports, but this particular report should only be available to select users(all which share that username). Any way to mask an ssrs parameter input so that it on...more >>

SS2005 64bit is installed and running fine on my copy of Vista Business 64 here I've gone into Programs and Features and enabled all the IIS/ASP.NET stuff posted on the internet. I've also created a IWAM_computername account and added it to the Administrators group. The setup program ...more >>

Hello Fellow RS Has anyone ever heard of or tried adding to the report export list? I've read through the BOL for report export options and searched the web for advice. There is quite a bit of information folks have shared on ways to export stored procedure results to a fixed length text f...more >>

I have a report that contains a single chart. That report works fine by itself, and as a subreport in many other contexts, but... When I use that report as a sub-report inside a table, passing all of the parameters to the sub-report based on values from the current row of the table... T...more >>

I cannot create any subscriptions from Management Studio. Reports have shared Data Source with stored credentials SQL Agent is up and running In surface area configuration "Scheduling and delivery" for SSRS are enabled SSRS Execution account has been set up E-mail settings are fine I'm logge...more >>

When I go to inetmgr => Web Sites => Reports The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. -------------------------------------------------------------------------------- A...more >>

Hi all I have a scenario where I need to retrieve scanned images for a report. The plan is to have one page showing items submitted from a table and the remaining pages producing the linked scanned images. the scanned images will probably be PDF or data held in XML format. I am thinking th...more >>

I have a _very_ simple table with just one row and three columns. The first column of the row contains a subreport that retrieves a single value. The second column of the row contains a subreport that retrieves a single value. ....and heres where I lose it... :-) The third column sho...more >>

I am having issues installing the reporting services addin for sharepoint. While the installer claims the install was successful, I do not see the features in Sharepoint Central Administration. A look at the install log shows that the install failed. I am logged in as administrator, this ac...more >>

Hi, I have a report with parameters and need to get it via C# in PDF Format. Need an example that works. Thank you, ...more >>

I have freshly installed new OS and SQL 2005 with Reporting Services. When I try to navigate to ReportManager I am getting "Cannot connect to remote server" message. What can the problem be? Thanks ...more >>

I'm working on SSRS 2000 to start off with. I have a subreport that takes one parameter. It worked beautifully until I had to change my result set to include records that did not always have the necessary value for the parameter so my parameter went from.. parameter = fieldname To para...more >>

Hello everyone. I am still trying to get SQL Reporting Services to work with MSPS 2007. When I create a report and try to deploy it, I am prompted for a user name and password to connect to the reporting Server. I am working in the microsoft EPM2007 demo environment and am trying to use the f...more >>

I want to create a report with two columns with a single group heading with one table. I will use this as a subreport in a larger report consisting of single column tables. When I layout the report it shows two columns but when I preview the report it is just one long half-size column and neve...more >>

Hello. I have a report with parameter called "parm1", that gets a value of "true" or "false" depanding on another parameter. When the report is runnig the parm1 value is "false". How can I protect this parameter from a change by the user? I mean - the user can run the report and then add to t...more >>

I have a report "Clearance Summary Report: Each page summarized the total sales for one agency. Everything works great except for one total "Adjustments:" An agency can have one order but have 50 adjustments to that order. That is why the Adjustments can not be included in the "dsReport" que...more >>

Hi All, we have a little over 1000 lines of functions and code an we maxed out the code editor, and can't add any more lines. Any workarounds or suggestions? Thanks, Scott...more >>

I've figured out how to send multi-value parameters to my stored procedure using a split function when my parameter is an integer. However I need to do the same thing with a character parameter. It works for the first value, but that's it. Here's the function that I found: USE [EdCat] GO /...more >>

Hi, I am analyzing the internationalization support in SSRS 2005. I have the following queries. Query #1 Does Report Builder have internationalization support? a)If the browser language setting is french, will the report builder display french automatically? b) Or is the localization feat...more >>

I would like to require that the users select the "view report" button before the report renders. How can I do that? Also, can I trap the event for when that button is selected? how/ where? Thank you. ...more >>

Hi, We have a field in our dataset which we want to appear in the footer of each page in our report. To do this, we have added a textbox to the body of the report and reference this data in the footer using the following: =ReportItems!site_code.Value This works fine, except when the re...more >>

Hi all, Do you know that can we use 'distributed queries' in reporting services to create rdl report or use linked server as datasource. please advise if any direction, many thanks. e.g. SELECT s.sales_amount FROM access_server...region AS r, oracle_server..sales_owner.sale AS s, sql_serv...more >>

Hi I need some help with this case. I have the sample report like this: No# Desc Amount 1 Quantity1 (Pcs) 10 2 Quantity2 (Pcs) 15 3 Price1 ($) 800 4 Price2 ($) 200 Total ($) 1025 I want to get th...more >>

I have installed SQL 2005 reporting services and I configured it using Reporting Services Configuration. Now I tried to access to report manager using http://servername/Reports with login I used to start reporting services. It doesn't work and keep prompting me for login and password. But no use...more >>

Well I've seen several related posts but nothing seems to exactly fit what I need. I real new to RS so bare with me. What I have is a stored procedure that returns several elements of an address per row. For instance, Name1, Name2, Name3, Street1, Street2, CityStateZip. What I need is to colla...more >>

I have followed the steps outlined in http://blogs.msdn.com/sharepoint/attachment/4194088.ashx to try integrate my WSS 3.0 and SSRS 2005 sp2 instance. While the reporting services configuration says I am in Sharepoint integrated mode and it takes me to the sharepoint central admininstration...more >>

My company has SQL Server 2000 and is currently upgrading to SQL Server 2005. Is there an easy way to determine if the Reporting Services module is installed. I have access to Enterprise Manager and Query Analyzer. Is it possible to use either of these tools to see if it is installed?...more >>

Does anyone know of a way to control the width of the parameter drop down in Reporting Services 2005? When a parameter is not multi-value the width is adjusted to the largest member, but when the parameter is multivalue it appears to be a fixed length regardless of member size. The result ...more >>