Hello, I am having a problem when exporting a report to Excel. I am using the SQL RS web service to render a report. It seems that the report is always rendered using parameters default values. It is not using parameters that i pass to the service. I am having this problem only when render...more >>

I'm trying to install where a "Default Web Site" may have been deleted on IIS... I install and get no errors... When I open IIS and check there's no trace of report services... IF, and I say IF, if the DWS had been deleted, is there a way to get things working again on this server? I've tri...more >>

I have parametro call client, who is a list of clients, taken from the data base to traves of a query, access the report through the URL, by means of Internet to explorer, in some cases desire of passing parameter clients already selected and who the user who is seeing the report cannot modify it...more >>

Hi, I use the following syntax select multi parameter like 1,2,5 and if the parameter is empty then get all data. ="SELECT OrderID FROM Orders " & IIF(Parameters!ID.Value="","","WHERE OrderID IN (" + Parameters!ID.Value + ")") And my problem is.. IF I want to select 3 parameters, ID, Name,...more >>

I have created a web app that uses the reporting services Web Service to pull reports from the SQL Server. The web server is on one machine, SQL Server on another and I use the web service to get the reports. I do not use URLs in any way in order to keep as much information hidden as possible....more >>

I am installing Reporting Services on a Domain Controller, Windows Server 2003. The database needs to be a remote database. I am using a sql server login that is a dbowner of the master database. I keep getting an error when it tries to configure the databases. In the error log it says...more >>

Hello...we have an asp.net application and I have been looking at replacing all of our reports with SQL RS. However, we do have a requirement that we need to be able to print some mailing label reports. Is this possible with SQL RS? If so, are there any examples or articles I could review? Tha...more >>

Any subscribed report I attempt to deliver via email is failing with a strange error. The Report Manager Status indicator says: Failure sending mail: An internal error occurred on the report server. See the error log for more details. The error occurs when the email is triggered via snapshot...more >>

Is anyone using SourceSafe with Reporting Services? I'm just wondering how others might be managing/using solutions, projects and reports in SourceSafe. The problem we're having is that we've tried to put several reports in one project. In order to open a project, the .rptproj and .rptproj....more >>

How can we give serial numbers to the records in a table ...more >>

I'm not quite sure if i'm aiming for the impossible, but: In a matrix, i have time (weeks) as columns, items as rows and qty as detail and i would like to have a running sum for the columns. This problems arise because i need to columns to be dynamic. Any suggestions would be more than wel...more >>

Hello, I've written my own custom delivery extension for our Intranet application and the actual delivery extension works great! The only minor quirk I've found is that even though I'm updating the status property of the Notification class, it's constantly reporting "New Subscription" in Re...more >>

I have a quite complex report with a header and footer (displays on every page) that must be renedered as pdf. In the body I have a table within a list. This works well and is relatively quick with SP1. However if I add any expression to a field in the header or footer the pdf file takes 4 minute...more >>

Anyway to pass a null value as the preview and through the URL? I saw some posts about this, but was unable to discern the answer. Some of the parameters are optional in the sproc and need to be able to be passed as NULL. ...more >>

Is it possible to put reporting services report (rdl) on web server that does not have sqlserver (SqlServer is on the other machine)? I am using reportviewer control, and this is working as iframe with http address where is reporting service's web service installed but my customers have not ac...more >>

Hi! I get suddenly the following error when accessing the error: "The underlying connection was closed: Unable to connect to the remote server." The configuration has not been changed......!?! Greets Chris ...more >>

Greetings: I have a report with several subreports placed in multiple rows of a groups footer. In the Visual Studio environment, the Main report and subreports perform as designed including filtering data based on a parameter in the Main report. However when I deploy and publish, the subrepo...more >>

I have a 100 page report that I render as PDF and then show in an IFrame from a C# Ascx user control. It takes about 3 minutes to render if ONE person is rendering the report. The CPU goes to about 50 %. If TWO people attempt to render the report, the CPU goes to 100% and the reports don't re...more >>

Hi, I've created a report which displays in the Report Viewer as several pages which the user must page through to see all data rather than scrolling down the browser. Can the Page Breaks be removed altogether? I've used the MHTML render format but it's still got the page header and footer repeated...more >>

Does anyone know if SP1 includes any fixes to the file size of Excel files. We are trying to replace an old reporting tool with RS; however, when exporting a relativly small report the Excel file in 5-15 MB. Has SP1 addressed this issue? There are similar problems with PDF files as well....more >>

Can anybody tell me if the following should work: I am trying to start a report services session by calling the Render method in code. This works fine - a session ID is generarted in the SessionHeaderValue. Now, I would like to able to that same session via URL. Here's the VB code snippit: ...more >>

I have a user who is getting an error when trying to pull up any report on Reporting Services. All other users are having no problem. His error is the following... An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot read the next data row for the dat...more >>

I have a table on the left hand side of a page and some fixed text on the right hand side of the page. Unfortunately, as the table grows, the text on the right hand side of the page is forced down the page. How can I keep the text fixed at a particular point on a page, no matter the size of the ta...more >>

If anyone out there has been successful in connecting to Sybase ASE 12 from Visual Studio .NET 2003 either in a Windows Forms or Reporting Services project, can you please help me. ..... In summary, I wish to: (a) create a Windows Forms application using VB.NET (Visual Studio ..NET 2003 ...more >>

I have a field on my report which needs to show an amount in Euros, so I have the Euro (€) symbol in the report. This looks fine when I render the report in HTML and Excel, but when I render in PDF the text is all messed up. This also happens for some other characters with an ASCII code above 127....more >>