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 >>

Hi, I am developing a few reports using the Micrsoft report server which create a "RDL" file. I was wondering if I can directly transfer these reports to my ASP.Net application and convert them to the RDLC format? can anybody provide any information about this functionality? Thanks ...more >>

I have a Report Viewer control on an asp.net page. The report shows the parameters. When I choose a value from the drop down and then click on "View report", the screen gets refreshed and the parameters are reset. It's like no parameters have been selected from the drop down and no data is sho...more >>

In my Table, I am using the following formula to avoid getting a Divide By Zero error when a Goal has not been identified but I am still getting the error. What am I doing wrong? =iif(isnothing(Fields!Goal.Value),"No Sales Goal",(Sum(Fields!GP.Value)/fields!Goal.Value)) TIA Dean ...more >>

Is there a way to improve the inital load time for the SSRS Report Manager website? It is my understanding that the first time you access the site (http://localhost/reports), SSRS has to compile all of the corresponding ..aspx pages behind the scenes first, then the subsequent load times of t...more >>

I am working on an aging report and am trying to sum one of the columns that is the 30-60 Day bucket. I have the expression written as the following; "=sum(fields!extcost.value) where (fields!interval.value>30 and Fields!Interval.Value<=60)" What logic should I be using? Thank you, ...more >>

Hi All, can anybody please tell me how to use below sql function.I have a requirement to convert rtf formatted string as plain text from sql table.I found below sql function in google search. but I dont no how to use this.what is 'RICHTEXT.RichtextCtrl' ? CREATE function dbo.RTF2Text(@in va...more >>

First let me apologize...I am using SSRS 2000 and I haven't worked in it in 2 years so I'm having trouble with some very elementary stuff. I need to get the database name in a footer. Any help would be greatly appreciated! Renee ...more >>

I've been experimenting with the different options for connecting to Analysis Server. At one point I selected "Credentials stored securely in the report server" and put in a User Name ("dummyUser") and a Password. Then I decided to try "Credentials are not required". When I did this, the r...more >>

We have a new server (Win 2003, SQL 2005) and have been trying to migrate the report server database from an old server (Win 2000, SQL 2000). After a number of false starts it appeared everything was working but when running a report we get the following error; =B7 An internal error occurred...more >>

In the ReportServer database there is a table named Executionlog, which contains data on the reports executed. But at any given time, it only seems to contain data for the last 2 months. How do I change this filter? ...more >>

Hi, Is there any way to implement export to ms word ? it seams that reporting just support export to Pdf,Excel and Image. Any suggestion? Is there any plan on Microsoft for supporting Export to word ? Thanks, Saman Zakerzadeh...more >>

Hi, I have a report with 2 parameters, start_date and end_date. If I use default parameters the report runs straight away. I want to have the default values to save the users typing, but I do not want to run the report until the user clicks "View Report". How do I do that? Thanks in advance....more >>

hi all, i use a query that returns a set of projects and customers for my report. i am using a multi value parameter to filter the projects in the data. because the grouping is done in the report itself, when i try to set the mvp from my query each project apears multiple times on the dropdown...more >>

Hi I am trying to create a scale-out deployment of Reporting Services 2005 on a NLB cluster web farm by following the instructions in: http://technet.microsoft.com/en-us/library/ms159114.aspx However, when I install and configure Reporting Services on the second node, and then go back to th...more >>

Hi, I just finished setting up a Windows 2003 SP1 server (X64) with SQL Server Reporting Services 2005 SP1. When I check reporting services configuration manager everything looks fine. The service is started, the virtual directories are setup. As the windows service identity I used Local...more >>

I have a matrix in which I added 4 additional rows to perform running values calculations within the grouping. I am attempting to add a Total to the bottom of the matrix and instead of getting the totals from the multiple groups, I am just getting the value from the 1st group. It is totaling ...more >>

Hi, I'm looking to confirm what I suspect - that if I have a single stored procedure that returns 2 results, I can only "design" against the first result in the designer. I realize that I can create multiple data sources, and call the stored proc twice with a parameter to indicate which of ...more >>

I am trying to set up Reporting Services on one of our servers. It is set up and I can get to the reports by typing in http://localhost/reports but when I try http://<servername>/reports I get page not found - this also applies to any files in the default website. I think it is something straight...more >>

We plan on deploying a single computer A running MULTIPLE instances of SSRS2005 EE. Each instance will be configured to connect to a report server database on a remote computer B running SQL Server 2005 EE. Does this scenario require: a) a valid license of SQL Server 2005 for EACH ...more >>

I have developed a report from a word document that has 15 lines for names and information. If there are less than 15 names for a specific category, I still need to print out rest of the lines (each line is numbered with rownumber(nothing)) and framed with borders to fill out the form to mimi...more >>

I am trying to add a web reference to an Access 2003 database form using the latest version of the Web Services Toolkit. When I try to add the reference it runs for a while and then blows up with the following message. Cannot Create Class. The Web Service References Tool could not generat...more >>

We have a SQL Server 2005 application that we deploy most of the time on SQL Express, not full blown SQL. We have a Development box here (2 CPU XEON with 4GB RAM) that has the Developer Edition and an instance of SQL Express installed. If I run the same reports, with the same data, but one o...more >>

How do I get a row to display conditionally? For example below - I = don't want the shirts row to display because it's zero. I'm using = Report Builder against a Cube: Products: Qty: shoes 5 shirts 0 gloves 10...more >>

Hi, I have a LocalReport, when I'm exporting to a PDF using the following code: Warning[] warnings; string mimeType; string encoding; string fileNameExtension; string[] streams; byte[] pdfContent; string...more >>

I am missing something very basic. I cannot see or find the Subtoal Green Triange to get the subtotal properties window. I have tried both the table and matrix controls. Thank You. -- Robert Hill...more >>

How can I have a boolean parameter show yes and no instead of true or false? TIA dean ...more >>

The Server name has been changed. When installing reporting service the service starts up fine i get the following 2 events in the event viewer 1-The report server database is an invalid version. 2-Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database. ...more >>

Can anybody point me in the right direction for some good reading to help a newbie with the reporting services offered by SQL-Server. I'm able to right queries in SQL Server but have been asked to learn reporting services. Any help greatly appreciated, Jason ...more >>

Hi, I figured, that I can call reports directly via URL and pass the appropriate parameters in the URL when adding '&mypara=value'. So far so good. But I could not figure out so far, how I can pass parameters that allow "multiselections". Using the above notation doesn't seem to work ... :(...more >>

Hi, I'm using SSAS 2005 cube as Data Source for my SSRS 2005 report. The report has parameters as well. The requirement is that I want to pass parameters to the report using my own UI. My questions are: 1. "How to pass parameters to my report using my UI?" I'm developing the UI using VS...more >>

I have recently configured SQL Server Reporting Services 2005 on a Windows 2003 Server. From the Report Server Configuration Utility, everything looks like it is set up fine, but when I go to http://myserver.com/reports I get the following error: The request failed with HTTP status 400: Bad...more >>