http://www.microsoft.com/windowsserversystem/default.mspx "Download SQL Reporting Services SP2 and New Report Packs Get the latest downloads for SQL Server Reporting Services, including Service Pack 2 and new report packs for IIS and Great Plains." ...more >>

RS 2000 SP1, and I have verified that all of the Page.Width, Body.Width, and margins are appropriate. The report in question calls a stored proc with 2 input parameters. I have verified that the SP is working fine, and returns all expected data. I see all of the data when I look at the report ...more >>

Say I have data like so: resource, avail_resources A,3 A,3 A,3 A,3 B,5 B,5 B,5 B,5 C,25 C,25 D,4 D,4 The avail_resources data repeats for each resource in the dataset. I am grouping on each resource and know how to show the avail_resources for each resource by using =FIRST(Fie...more >>

I do a lot of work with a report that calls a stored procedure that takes about 2 minutes to complete. It annoys me that when I change one little formatting property in the layout, I have to wait for the stored procedure to run again before I can see the results of my modification. I wish th...more >>

Hi all, I'm designing a report that requires a table cell to be able to jump to another report. This cell needs to be conditional so that if a numeric value is present, it blocks the ability to jump to another report (and takes away the link mouse cursor), and if a non numeric value is pre...more >>

Hi folks, Please please can someone help, this problem has just been going on for too long.We need to run reports off RS using AS as the data source. Our setup is as follows RS - on seperate web server (srvWeb) RS DB - on seperate SQL server (srvDB) No problem - everything has...more >>

When I create a report that has imbedded subreports there are occasions when I get a blank page between the main report and a subreport, this occurs when exporting to PDF. From what I have observed; if a subreport contains more rows of data than can fit on the same page as the main report then ...more >>

In crystal, it's very easy to filter on a column by using top n or top %. But I keep getting error in MS Rpt on this. Basically I have a simple table which groups on product name, and columns that displays the combined sales for the product. I want to show the top 10 product that have the most ...more >>

I have a upper report that I want to dump details to an excel file for the user to crunch and much. some of the details could be 19K lines, I tried to use the export of the detail report but it locks up. ...more >>

I'm producing a report that will generate 1 or more pages. Each page should have the appearance of a full page of empty grid rows (approximately 20 per page), even if only 5 rows contain data. My layout will accomodate 20 rows of data per page and each page looks good as long as my row count...more >>

I already have SQL Reporting installed and I have previously created reports using the Report Designer via Visual Studio .NET. Since then, I have had to build a new Laptop and get Report Designer Componenets installed on my Laptop. To add to the fire, I now have an assistant with a his own...more >>

Does anyone know how to put a border on individual cells within a table? Thanks, Denny ...more >>

How can I retrieve the version information for SQL Server Reporting Services to verify that Service Pack 1 has been installed? Is there a site/page that lists the version information details and instructions for retrieving this information? thanks, -- Paul...more >>

I am trying to use the ReportServerVersionNumber property of the ServerInfoHeader class, and I receive the error that the object reference is not set to an instance of an object. The code looks something like this: rs.Credentials = System.Net.CredentialCache.DefaultCredentials Dim rstest As...more >>

Hi, I have installed RS in a production environment successfully. I then added a user into the windows registry. I can access all 'tool bar' options like 'Upload Report' as an administrator on the localhost, but when I access RS by the new role I have created I only get the almost blank 'home...more >>

Hello I have developed couple of reports. I am using Sql Server 2000 as datasource and which is at other machine and not on the development machine. When I try to access report from my machine I can access the reports using either http://mycomputerIP/Reports or http://mycomputerIp/Rerport...more >>

Initally we set up SRS to deliver reports via SMTP and now we would like to use Exchange. Is there a document anyone has seen that discusses how to configure this? I know an <extension></extension> of some sort needs to be added to the RSReportServer.config file under the <Extensions><Deli...more >>

This has been asked many times before but without an answer so I thought it might just be worth trying again: Does anyone know why a subscription succeeds with a link only but fails when the report is included with a status of: "Failure sending mail: The Report Server has encountered a conf...more >>

I have a business requirement that requires implementing column "masks" depending on the user running the report. It seems as if a DPE would be my best solution. Ie. I propose modifying the DataReader to blank dataset columns in specific circumstances. To prove my concept I would need to exp...more >>

Somewhat newbie here trying to deploy my first Report. Production machine is on Windows 2003 - finally got around the reporting service prompting for windows authentication and now I'm trying to deploy my report through VS 2003. Which reports successful deployment. If I press the "Run" butt...more >>

The following are the steps I follow to access the chart's scale. 1. Right click on the chart and choose properties 2. Click the Y-axis tab. 3. Under the Scale heading are the Minimum and Maximum fields. I'd like to be able to set the minimum and maximum fields using a formula which i...more >>

I have four reports which currently exist as part of one Excel file. While they can exist separately, I'd like to lump them together as one deliverable in order to maximize transparency to the user. So, what I did was create one matrix or table for each report type and put them all in one. ...more >>

I have xp sp2 and .Net framework 2.0 installed on my computer.now I'm trying to install RS on the same box which I get the error stating that ASP.NET is not installed on my computer.How should I make the installation know that ..Netframework 1.1 is installed on IIS? Thanks ...more >>

I am having major pains due to merged cells... I need them, but they're causing lots of problems in terms of the report layout. My current report is laid out like this: Detail row a: Date Int Date Int Int Int Int Int Int Int Int Int Int Detail row b: Date Varchar2 Varchar2 Basicall...more >>

When I click on a report that has been deployed, I am able to view the report via the web if I am looking at the report on the localhost. If I connect to the server and try to view the report, I can see the reports, but once I click on the report to view it, the page times out. It's not gene...more >>

I would prefer to dynamically create my RDL files on the fly instead of building them ahead of time. My question is this: the creation of these files would occur on the server, but the reporting server may or may not be the same box. Is the best way to upload the RDL file to use the web servic...more >>

I have one report, with several links to it. I updated the text for the parameters in this report, however when I pull up the linked report, they still have the OLD text description. I saw another post about this, with a suggestion of hitting f5, or ctrl+f5. I tried all of this, but nothi...more >>

I am on security doubt on how to design a report that must show the accounts of a customer. I have an aspx page showing the customer info , then he must push a button a see its accounts on a report generated by Reporting Services. Obviously the report can not be accesed via a Customer paramete...more >>

When I export a report to pdf I sometimes get the error 'There was an error opening the document. The file is damaged and could not be repaired.' When I give different parametervalues there is no problem with the export (of the same report). I examined the created pdf-file (with notepad) an...more >>

I know that there is a print button with RS 2.0, but is there a way to add the button on the current version of report manager? Thanks, Trint ...more >>