guys, I am exporting a report in excel that generates in different sheets. It seems that only 3 tab or sheets can be generated. If the report exceeds 3 sheets all the rest of the sheets combined in the last sheet. Can anyone confirm this? Does it have any work around or I am just doing som...more >>

Hi, I am still trying to get my head around the ReportViewer control. I thought that this control would enable me to run reports without connecting to the database. Am I wrong? I tried the walkthrough "Using a Database Data Source with the ReportViewer Windows forms control in Local Proc...more >>

IS the installation of RS 2005 EXPRESS is with the SQL 2005 EXPRESS or should i download it?...more >>

Hello, We have an public site with a page now using ASP.NET 2.0 and the 2.0 Report Viewer control (we previously tried this with RS 2000 for many, many months). It is connecting to a (NAT'd FQDN) SQL2005 Report Server using default Windows authentication. There is a local user setup on th...more >>

I've got a real annoying problem. I'm trying to do SSRS project that is of course already late. And I have been stopped cold by this freaky error. So I'm using VS.Net 2005, Reporting Services 2005 and have the Business Intelligence Projects in my VS.Net. I create a new Report Project. I right ...more >>

Is it possible? Crystal allowed you to do it but RS doesn't seem to. I have a number of reports that need to display same data (Org name, date etc.) on the report header and I thought doing it as a subreport was a good idea. Any workarounds? Thanks in advance. ...more >>

I am having issues with getting our Development Report Services Server to schedule any reports to run. Recently, I had to change our service account to a non-expiring one and now I get the following in our Event Log. Schedule and Delivery Processor Failed to decrypt symmetric key. Most like...more >>

RS is installed on the same server with the WebServer. I run this from a domain network PC: http://WebServerName/Reports/Pages/Folder.aspx and I receive this error: The request failed with HTTP status 401: Unauthorized. What I checked: 1.On the WebServer go in IIS , then Default Web Site, th...more >>

I have a need to report on all the ticket numbers assigned to each indiviual. Currently, i have one report that queries for all the individuals, and in the table calls a subreport. In the subreport is a matrix that displays all the tickets assigned to that individual. The problem that i'm...more >>

I am using SQL Server 2000 and VS.net 2003 with Reporting Services. I have deployed several reports. I am trying to open a report to edit it. When I click on the data tab, I get the following error: A connection cannot be made to the database. Set and test the connection string. Log...more >>

When trying to print an RS2005 report, I keep getting the error "Unable to load client print control". This is because the RSClientPrint ActiveX control is not loaded. I have noticed that in IE7 Beta is not automatically prompting to download the control. Has anyone been successful in runni...more >>

Does anyone know how to populate a cell with the name of the field being grouped on? For example, I have the following structure: Heading Group Data I won't the Heading to display the fieldname of the group by using a formula, so if the group changes so does the heading value. B...more >>

I am converting reports from business objects to reporting services. In business objects they have a variable called ERRORS created with the expression = If (<Value> InList (12 , 500 , 501 , 502 , 503 , 504 , 505 , 530 , 550)) Then 1 Else 0 <value> is a field returned from a stored proc...more >>

I have two different databases DB1 and BD2. which one table in each. TableDB1: ID, Amount1 and TableDB2: ID, Amount2. Now my sub-report should report ID and sum of DB1.TableDB1.Amount1 and DB2.TableDB2.Amount2. Should I create two shared data sources? How should I write my query? ...more >>

Hello All, I've been struggling with this error for the past day or two. "The underlying connection was closed: Unable to connect to the remote server." I get it when I try to access the Report Manager. The reports are working fine - I access them through the ReportServer. However I can't...more >>

Hi Everyone, when i am runing report with url adress i see the report ok, but i also see the textboxes of the parameters on the top of the scerre. is the a way to not show them? and is ther a way to show the print button? thanks Ruby...more >>

The page number shown on the web report viewer control is different from the page number for the print version, does anyone know how to correct it? Thanks in advance. ...more >>

Hi, I am doing the MSDN Online tutorial "Accessing the Report Server Web Service Using Visual Basic or Visual C#". However, when I come to the 3rd step, Accessing the Web Service, and use the supplied code, I get an error saying "Namespace or type specified in the Imports 'GetPropert...more >>

Hi Presently I'm working with OLAP and Reporting Services. In which users are allowed to drag and drop the dimensions and the measures from the list available for the cube , On droping of the dimension/measure on Row/Column. I need to generate the matrix. Is it possible in RS, If it menas, g...more >>

Hi, We are using SQL RS to generate PDF billing statements. We need to print a vertical barcode at right side of each page. The barcode is going to be read by the envelop machine and must be at a precise exact location. We have the barcode font and it works fine. How ...more >>