When I try and run a report in mom2005 I get the following message: Reporting Services Error -------------------------------------------------------------------------------- An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for da...more >>

We have a batch-driven system where we receive data files in the evening and process them in the early morning. When this is complete my database(s) is updated and can generate the day's reports. The problem is that we rely on another party to provie the initial data and the time that our processi...more >>

Open to any suggestions on how I can work around this problem. I have a report that renders to Excel and depending on input parameters can contain anything from 10 to 200+ sheets. Due to the limitations of RS the sheets are named Sheet1, Sheet2, etc... The report layout and delivery format...more >>

Is there any way to allow the end user to print the report output without having to export the results to a .pdf file? -- Lisa...more >>

Hi, the problem that I'm having is when passing a parameter into a report that is using that value in a LIKE clause. Reporting Services seems to be taking the SELECT statement and turning it into an = instead of a LIKE. I have a column in my table called "Category" of fixed length, which ...more >>

Hi - We have 5 IIS servers as part of our application environment - DEV, TEST, DEMO, QAT, PROD. Developers develop locally with VS.NET 2003 + Report Designer (IIS installed locally) and then push the code to the respective environments. For our RS deployment, we opted to install one RS insta...more >>

I have created a RS report that contains 2 datasets and 2 lists. This is a consolidated corporate report grouped to return data for 53 companies (one page per company). Both datasets return data for all 53 companies when viewing from the data pane. However, when the report is viewed in the ...more >>

Is it possible to change the colour of the interlaced strips? I can change the default background colour, but haven't found a setting for the alternate colour. I need to have two light colours, as the default gray is a bit dark for some printers. All help appreciated! Kaisa M. Lindahl ...more >>

Hi - In our RS + SP1 installation on Windows Server 2003, we recently began to get the following error: "Unable to get report parameters: Unable to access Web Service: The request failed with HTTP status 403: Forbidden." We are calling Render() in code using an account which has admin righ...more >>

My DB has 3 tables Employee, Department, Job I want to create a report with two parameters. Parameter 1 Options: Employee, Department or Job Parameter 2 Options: When user selects Employee from parameter 1, all employee names will be made available to select in parameter 2, When user ...more >>

Hi All, I have one report which has chart and a filter ,I am deploying **exactly the same Report** to two different Report Servers.On one it is working and on the other one I'm getting this error: An error has occurred during report processing. (rsProcessingAborted) Get Online Help The proce...more >>

I have parameters coming into a report. I need to apply a case statement to translate coded parameters into user recognizeable text and display them as part of the header. Doesn anybody know how to do this? Example: aspx page receives paramaters...passes params to url and launches report. ...more >>

I have parameters coming into a report. I need to apply a case statement to translate coded parameters into user recognizeable text and display them as part of the header. Doesn anybody know how to do this? Example: aspx page receives paramaters...passes params to url and launches report. ...more >>

Report works fine in HTML and exporting to PDF but when exporting to excel and opening the file we receive a notification that errors were detected and a repair was attempted. The repair notification states that the damage to the file was too extensive to repair and the file can be opened with only...more >>

Hello, I have 3 row groupings and one column grouping. The visibility of the 2nd two row groupings is toggled by the first. For each value in the second grouping there is always only 1 in the third (like a first name and a last name). Therefore, I need two subtotals, one for the first row ...more >>

Hi, I am Installing Reporting services enterprise Version On Windows 2000 Server with SP4. The Installtion went smooth except at the finish dialog it gave me the Warning message "Setup could not initialize the Report server. you must manually initialize the report server" My reportserver ser...more >>

Hi pals, I am asking you for your wisdom: When user click to: /ReportServer?/test/This+Is+Test&rs:ClearSession=true&rs:Format=PDF&OrderID=532 I want to: 1. define the name of PDF, I have always "This Is Test.pdf" and I want to change it let say "Document 532.pdf" 2. open PDF in new ...more >>

I am using an external assembly on one of my report. This assembly simply does some data reading, does some calculation, and updating a table, and is working fine if called directly from an aspx page. However, if I call the assembly from my report it fails with an error below: Reporting S...more >>

Is it possible to format time using the 24 hour clock/military time? It would please my users as well as free up some much needed space by eliminating the AM/PM. I noticed changing my local pc's regional settings had no effect. Thanks for any help!...more >>

Hi, I have the following expression for one of the text boxes in my report: =Sum(Fields!totallagtime.Value)/Sum(Fields!openduring.Value) But now if division by 0 occurs, it shows up as 'NaN' when run, I would like it to show up as 0 if division by zero occurs. Any suggestions on how th...more >>

I am in the process of evaluating Reporting Services for my company. I succesfully installed Reporting Services and began developing a simple report. After closing Visual Studio to attend to another matter, I later re-opened Visual Studio and was unable to edit my existing report project. ...more >>

newbie to this. pls bear with me. background: sql2k and report server standard edition, on a w2k3 box. all sameple reports work great so far. I created a report my own, it went fine too. but when i changed the sorting order in report designer (in vs .net 2003), the preview looks fine, but when...more >>

Hi, I set up a standard subscription and am rendering the report to excel or pdf. After recieving the email, I open the excel or pdf report and it displays a bunch of garbage. SQL 2000 Reporting Services SP1 is installed. Our email system is Novell GroupWise 6.5. Can you tell me if thi...more >>

I don't know if I've quickly hit a SQL Reporting Services (SRS) architecture limitation, but here's the situation. I have a report based on a single query that accepts 3 parameters: 1) Company (0/1) 2) Month (Date) 3) Retrieve either YTD or Monthly values (0/1) Executing the query in Qu...more >>

Hello, Is it possible to get a comprehensive list of bug fixes that SP2 addresses? TIA. -- Chris Hanley...more >>

Hello, I'm trying install the evalution version of Reportingservices, but I recieve an error message that says that I must register ASP.NET 1.1 on my web server. What shall I do? ...more >>

Hi all, Im using the custom code to format the string returned by the stored procedure in the reports. Public Function ResourceCategory(ByVal stat As String) As String Dim str As String Dim arr As String() arr = stat.Split(",") Dim i As Integer ...more >>

Hello! I've got a newbie question :(. Perhaps it is quite easy... How can I change report layout to landscape. To get the whole table with all columns on the table :(. And the second question perhaps has no answer... Thanks in advance for any ideas. My company wants from me a report wit...more >>

Hi hoping someone can help me... We Were running a stand alone version of RS fine on a laptop. the IT guys have completed a server installtion of RS. when I get to Report Manager home page and click on a report view the properties , and change the name of the report. I click Apply and nothing ...more >>

Is there somewhere a real usable sample application for this? I found some samples, but I'm unable to do anything with it. There are some source code files in the knowledge base. But I don't know how to apply the Instruction on compile them. I need realy step by step instructions for a nov...more >>

Hi there ..is it possible ? I'm new in this matter... Thanks in advance...more >>