I working through the 'Creating a Data-Driven Subscription' walkthrough supplied as part of the BOL documentation, using Report Server File Share as the delivery method. It cannot generate the report using the three sets of dummy user details. The resulting status is: 'Done: 3 processed of 3...more >>

Hi all, today I deployed new server with RS2005, and come to this problem: When I click in IE from web app to: http://10.20.80.20/ReportServer/?/foo/bar&rs:Format=PDF&rs:Command=Render I get SAVE AS dialog, thats OK. After pressing SAVE, it transfer 90KB (the same size as PDF have), but it ...more >>

Can we install RS2005 in a Windows 2003 cluster ? ...more >>

I have always thought I would like to give the user the abilty to mail themselves an Excel report, if it is a simple repeatable report with one parameter. Instead of trying to teach them or show them Report Manager, I wanted to create a simple app that would allow them to put in a parameter for...more >>

I'm using RS2005 for my client's reports. They like the export feature to Excel, but asked what happens if the data exceeds Excel's 65,000 row limit? Does it put the remaining rows on another sheet, or does the export fail? What are my options using RS2005 if the data exceeds Excel's limits?...more >>

I have to reports, ReportA and ReportB. Both uses datasets that are based on OLAP cubes. Both reports has parameters and works fine. My challenge: When clicking in a field in ReportA, I want to navigate to ReportB, sending the appropriate parameters from ReportA to ReportB. The first parame...more >>

We have just upgraded to SQL Server Reporting Service 2005 and our reports were consistently generating 'rsExecutionNotFound' errors, like the one shown below. The errors happen when a report was refreshed or a drilldown '+' was clicked 90 seconds after the report was initially delivered. ...more >>

With SSRS 2005 is it possible to set up a second virtual directory and maintain a separate second instance of Report Server? If I use the Report Services configuration tool will I be causing conflicts with the first instance of reporting services? Any recommended way of doing this? ...more >>

I have 300 odd reports on my sql 2k server, is there a way to track and view the usage for the reports? ...more >>

We're currently evaluating Reporting Services 2005 vs. Cognos ReportNet. One issue that's coming up is are the software requirements for general users to use the Report Builder feature. Cognos is a zero-client install product. RS 2005, on the other hand, requires the following of users: + ...more >>

Hello i have an expression build on RowNumber and i realized it counts hidden rows (visibility = false)... this seems very odd to me.. is the way it was designed??...more >>

Any Microsoft support people that can answer this? This is simply unbelievable! Wow. This is unacceptable. From all my years of working with Microsoft products, this is the worst installation problem yet. I already asked this question but didn't get a proper answer. I do not know where els...more >>

Hi, We use two IIS machine hosting each an instance of Report Server. The RS database is located on a SQL2000 SP4 cluster where no component of RS is installed except the RS and RSTempDB databases. We upgraded each IIS machine and the setup completed without any errors or warning. In th...more >>

I'm trying to create a report model in visual studio. I need the model to report against an exiting cube. I can easily make the model in SQL Server management studio. When I try to do the same in Visual Studio I run up against a problem when I try to create the datasource view. The steps I'm tak...more >>

Hello, For some reason all of the suden any subscription I make will not run.. The status just stays at "New Subscription". I made a test schedule that runs every 5 minutes. I have even added old subscriptions to this schedule and I get email every 5 minutes. Why would Any new subscript...more >>

I get the following message when I try to export a report to pdf. It works for other instances of data. Not sure if there is to much data, a character that is messing up the export or what. Any ideas? Server Error in '/Reports' Application. ------------------------------------------------...more >>

On one of my table-based reports, my client would like to have a row of data which includes an expandable field for Marketing Plan. Initially, the client wants to see a count of the Marketing Plans based on the parent grouping. That is not difficult. However, the client then wants to be able...more >>

I know there's been a lot of discussion here about passing parameters, but I don't seem able to get them to work - I'm sure I'm missing something simple... I'm using a ReportViewer control on an ASP.NET 2.0 page to call a remote RS2005 report and want to be able to pass a value to the paramet...more >>

Hi In Crystal it was possible to "Underlay the following section" i.e. Display the group header over the top of the detail for a group or display the report header over the top of the table within the report. Is it possible to do this in SQL RS? I have also been tring to create a waterm...more >>

Hi I have designed a report on Invoice details and grouped by Invoice Numbers and also applied page break on this group. I need to reset page numbers on each Invoice number. Is this possible? Anyone know how to do this? I am using SQL Server 2000 Reporting Services. Thnx Dimpu ...more >>

We are currently running RS 2000 SP1 We had a contractor in who setup a subscription to a report using a temporary AD account. He is therefore listed as the "owner" of the subscription. His account has now been disabled in AD and I'm unable to change anything in the subscription! If ...more >>

I have a report where it displays demographic information. The Address2 field is sometimes NULL and I haven't found a way to suppress this field. The only thing I can do is make it invisible/visible with an IIF statement. I know in Crystal Reports you could check a box that said "SUPPRESS IF B...more >>

hi, i would like to ask why is it that when i run my ms reporting services setup, it always show the "asp.net not installed or registered on server" and "visual studio .net 2003 not installed" on the system check pre-requisite?, my pc is with ms XP, VS Studio 2005, IIS, SQL Server 2000 with SP...more >>

Hi, I have a problem with small pie chart slices. As you know in a pie chart, very small slices are unreadable. So I'am looking for a maner to GROUP little values of a graph in one categorie (slices) called "OTHER". For example all value under 1% will be grouped in the "OTHER" category ...more >>

Hi all, most of all works like charm, but I'm thinking how to define database data source for my custom assembly. The best option would be use same datasource as is defined in RS, it should be in some way shared ? Now I have defined it like: connSql = New SqlConnection("server=localhost;ui...more >>

Hi, In my application VB.NET 2005 application I placed a ReportViewer, and link it to a server-report: Me.ReportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote Me.ReportViewer1.ServerReport.ReportPath = "/myproject/DemandeDeCotation" Me...more >>

Hi, I am new to SQL reporting service (2005). Will like to find out can report builder open a report created by report designer. My scenario is like this, I will like to create some reports for my clients using report designer. Afterwhich, I will like to a allow end-user to ...more >>