How can I make reporting services to calculate the sum of a value that is displayed in a group? When I insert the funtion =Sum(Fields!nuAmount.Value) in the footer of a group, I get the sum considering all values included in a detail. I only want the sum to be calculated from the group header ...more >>

Hi, I have an application that attempts to create a subscription through the Reporting Services API. I'm currently getting an error that states the "'System.Web.Services.Protocols.SoapException: A subscription delivery error has occurred. --> A subscription delivery error has occurred. -->...more >>

I am deploying reports from multiple "reports projects" within a single "solution". It allows for links on the Reports Server to each basic category of reports which is nice. The problem is that while developing, within the Visual Studio .Net IDE we need to add "shared" datasources to each p...more >>

I have the following "where" clause in a select statement. The @Year parameter is a string and the @Week parameter is an integer. WHERE (ColumnYear = @Year) AND (SUBSTRING(ColumnWeek, @Week, 1) = 'X') When the statement is executed on the data tab of the designer, the following messag...more >>

I realize this is a very basic question but: I've got a report where I have a header of let's say 5 columns. Then I want a detail line under this with 7 columns. I know I can make this work by using cell merges and having like 10-14 columns. It's a hack though. I've tried using a subr...more >>

I need to be able to set the ConnectionString for any datasources at run-time. Basically, I will design a report (against SQL Server 2000) and my application will use URL Access to call this report. Depending on which database the application is running against, the report should run against...more >>

I am consulting for a company who is looking at consolidating their reporting needs into a yet_to_be_defined "Enterprise Reporting Solution". They currently use just about every reporting tool under the sun: Access, Crystal, Microstrategies, ASP/Web, blah blah blah... Reporting Services is on ...more >>

I am new to the .NET world. I have created a Solution with some Projects in them for Reporting Services. I have successfually integrated SourceSafe with my environment and Added the solutions to Sourcesafe. Now I have a co-worker who needs to begin sharing my solution and Projects. I hav...more >>

I have been asked to create a reporting solution to existing ASP.NET web application using URL addressability feature. The application will simply have links to the reports on the report server. Problem is web application is using Forms Authentication. I have looked at white paper on Microsoft's...more >>

Hi, Does any one know how to restart Reporting Services Thanks and Regards Ponnurangam ...more >>

When you first create a data-driven sub and schedule it to run "one time" it works fine. Later, however, if you edit it to try and re-run it, you run into a problem if the subscription is set to run on a one-time basis only again. You select "one time" as the schedule and set the time you wa...more >>

If you are rendering a report using the render method of the web service, is it possible to manipulate the root of the links? I'm thinking about something along of the lines of the undocumented rc:ReplacementRoot command. Is the ReplacementRoot available as one of the <DeviceInfo> parameters...more >>

I have a set of parameterized reports. For each, I default some querries and do not default others so that when each report comes up, the user must specify filtering information. Everything works great in VS. But. Not under report manager. Defaulted querry parameters lose their defaults. No...more >>

Am I missing something when setting up Custom Authentication? We are testing with the Enterprise version but only in development. We'd LOVE to do it with the Standard Version so we don't have to buy Enterprise just for web apps. Bascially, I don't want to require users to login to the repor...more >>

This is a redundant post of another thread which may be found by seaching under the subject of "soap mismatch". I am reposting it here to draw attention to my ongoing problem. I noticed that there are three others who are reporting this problem, too. Could we please get a little help from...more >>

Hey all- This may not be the right place for this, but I am going to ask anyways. I am very happy with RS for the most part. However, Excel is limited and thats what I need to have control over. I have been given a directive to make the excel reports print without having to reformat them (...more >>

Is it possible to use a report parameter to determine the scale of a chart? I know it works with the chart title, axis titles, and various other areas, but it didn't seem to work with the scale. I'm doing a graph of CPU use over time and there are a couple 100% blips that cause my chart's s...more >>

Hi everyone! This question has probably been asked many of times and I apologize for asking again. What is the best way to display a report in a WinForm client? Thanks, Y ...more >>

Can someone tell me where the installation for the plugin on a client is located? I'm trying to run setup.exe on a client from the Enterprise installation but I get a 1603 error. It balks at an asp .net user account not being there. I have VS .Net installed....more >>

Does this functionality work? I've tried textboxes, rectangles...nothing seems to "repeat" when my data region (table) object spans multiple pages. Advise?? Thx, Russell ...more >>

I need to range my data to data that is only inside a certain month. The only user input I have is the last day of the month. Is there any way I can derive the first day and get the system to range my data between the first and last day?...more >>

Hi, I've seen similar posts to my question, but no answers. If anyone has a solution, it is much appreciated. I have data like this (from an Employee table joined with an Assignment table): EmployeeID HoursAvailable AssignmentID 1 8 1...more >>

Hi, I've got a matrix report set up that gives the following: column Group1 Group2 Row1 x y I need to calculate x/y and cannot get the scope straight. Any help would be much appreciated....more >>

Hi all, I searched over the archive, and I found in the message mid:7088471E-6E7F-4185-AC9E-865EDE5FC973@microsoft.com was little conversation about this. How I can change/hide 1 column width in the table ? I see only property box, without no expression, and also I can't get there 0cm width...more >>

Hi all, We've had a Reporting Services installation for nearly 6 months now with no problems. Reporting Services is installed on a Windows 2003 machine which is connecting to SQL Server 2000 databases. This morning, it was reporting that the URL to access the report server (http://serve...more >>

I have two datasets accessed from two different data sources. I would like to display the report by doing a join between the two. How can I achieve that? This join can not take place at data source level. ...more >>

I created a report I call from another report using "jump to a report" option. The called report is opening in the same browser. I need to open it in the new window, and if possible to make it a pop-up (smaller size). I didn't find any straight way to do it. Any workaround? Appreciate your ...more >>

Is there a way to set the priority of the reporting services report server? I have reports which lockup the whole server while executing. I do not want then to time out. It would be nice if they had less priority and took longer to run. -- Thank You, Leo...more >>

Hello, I have a real general question regarding implementing a custom reporting solution utilizing RS. I am being tasked with creating the solution and integrating it into our existing vb 6.0 desktop app. My thinking was to leverage vb .net for the solution, but am being urged to keep ev...more >>

I've installed Reporting Services on a Windows 2003 front end server connecting to a backend SQL server. When I try to open Report Manager (http://myserver/Reports), I get the following error message: Possible SOAP version mismatch: Envelope namespace http://schemas.xmlsoap.org/wsdl/ wa...more >>

I have a report where I need to display a field value from a data set in the header. Acording to RS BOL .... "You cannot refer directly to a field in a text box in a page header or footer. (For example, you cannot use the expression =Fields!LastName.Value.) To display field information in a...more >>

Hi, I’m posting now for the second time with this issue…hopefully can somebody help… We have to new installed Server with the same configuration (except hardware): - Windows 2003 Enterprise (fully updated) - SQL Server 2000 Enterprise SP3a - Reporting Services SP1 - Patch SQL2000-K...more >>