I am trying to install the Team Foundation Server Database onto my SQL Server. Set-up fils with the following error: "SQL Server 2005 Reporting Services service is installed on the data-tier computer. The service should instead be on the application-tier computer. Uninstall SQL Server 2005...more >>

Hi, stupid question....haven't tried it myself, so I'll ask.... I have a client who is using SQL Server 2000, and can't upgrade to 2005 anytime soon. However, I'd like to use SSRS 2005 instead of SSRS 2000 to build some reports. Can this be done? Are there any major issues? Thanks, K...more >>

Hi, I am writing a web application in c# that is attempting to get the parameters from a report on a Reporting Services 2005 server. I am using the following code: SQLReportViewer.ServerReport.ReportServerCredentials = new ReportCredentials(UserName, UserPassword, UserDomain); ...more >>

I'm having an issue with subscriptions. I created a subscription to email a report both to an external address and internal address. The subscription worked fine (Mail sent to .... ) in RS. The outside entity received the email, but the internal entity does not receive the email. Is there so...more >>

Ok, I am stumped. I am obviously missing something really trivial. I have searched this group and don't see my exact problem which is this: I installed VS 05, SQL 05 so that I could test out the BI Reports stuff. I can build reports. SQL works nicely. The report builder works nicely. I can...more >>

is it possible? then what should I do for this? ...more >>

Hello, I am trying to set up SQL Server Reporting Services in a dual server environment. There are two machines, app01 and app02, each running the Report Manager and the Report Server. These two machines sit behind a context switch, so that you may type in a virtual address such as "www...more >>

I have a production database server on windows 2003 server. I am wondering if it is adviseable to install reporting services on a clean production database server or to install it on its own server. The cause for my concern is that reporting services requires visual studio 2003 and .net 1.1 b...more >>

any idea on how reports in report manager including snapshots can be migrated to 2005 ? /michael ...more >>

Hi- When I use Visual Studio and the Preview method of viewing a report, any DrillDowns or Toggles operate quickly and nicely. However, when I deploy to the server and access the report via IE, the report behaves slowly, twitchy, and just oddly. It wants to reposition the data to put my to...more >>

Hi all, I´m designing a report with a kind of Ranking. I have a list of products and I have to show the totals by product. What I need to show in my ranking table is only the Top 10 records so I need to filter by something like "Top 10". My questions are: - Which is the correct expresio...more >>

Hi- Microsoft says "Use multiple datasets rather than subreports" - here's one example but they have it ALL OVER the place: http://technet.microsoft.com/en-us/library/ms159268.aspx Here's a snippet: "When deciding whether to use a subreport, you may want to consider using a data region instea...more >>

Hi, I'd like to make the Search variables in my reports part of the Header, so for example if I'm searching for dates and have @StartDate and @EndDate in the SQL statement, I'd like to add something like 'Report Represents Data From 1993-01-01 To 1995-01-01' or something like that. How ca...more >>

On one server the report services folder exists here; C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer On another server it exists here; C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer Why MSSQL.3 on one and MSSQL.4 on the othe...more >>

I need to find a conditional sum of sales if fields!Example.value = 0 (And same if fields!Example.value = 1) How do I do that in reporting services? Thanks CS ...more >>

I tried searching online and from MS's site so I apologize in advance if this is glaringly answered somewhere and my google-fu wasn't up to the task. An administrator installed SQL2005(and sp2) on a new Win2K3SP2 server but the server itself didn't have IIS installed or the asp.net component ...more >>

I am running 2000 with SP1. Here's what I've tried so far. I specified no prompt in the designer (put a blank) and deployed the report. I got the following error: Parameter validation failed. It is not possible to provide valid values for all parameters. I then deleted the prompt in...more >>

Hi, We are looking at replacing Crystal Reports with SSRS. However, we would like to understand the implications of doing so. We want the reports to be generated at the Server and sent to the client through TCP instead of HTTP. Is this feasible? Thanks in advance. Regards, B@ns....more >>

HI all I have RS2000 Report Server with a report that contains an image control. The image control value is a UNC path to an image (ie \\<server>\images\image.jpg. The <server> is a different server to the Report Server. I have setup the unattended execution account to be the domain adminis...more >>