=IIF(Int(Sum(Fields!ACC_G_T.Value))=0,0,Sum(Fields!ACC_U_T.Value)/Sum(Fields!ACC_G_T.Value)) I use this formula when the divisor is equal to zero,it wouldn't be occurred a error. But it shows "#error" when the divisor is equal to zero. When I change the formula like this: =IIF(Int(Sum(Fiel...more >>

Is there a simple way to reneder an SSRS report in PDF from an asp.net app? Could anyone point out how to do such a task? -- Regards, Gary Blakely ...more >>

When running the following code... ReportingService2005 _rs = new ReportingService2005(); _rs.Credentials = System.Net.CredentialCache.DefaultCredentials; _rs.Url = "http://localhost/ReportServer/ReportService2005.asmx"; CatalogItem[] items; items...more >>

Is there an example on setting up a chart report to allow the user too click on a bar and have a drill down to a subreport change what is showing in it by what was clicked...more >>

Is there an example how to setup a Jump To or drillthrough to open a new window with a detailed report when a cell of a matrix control is clicked as can this be done with a table? Mike...more >>

Hi: I have a very simple report that was created to create a csv file for a mail merge process external to SRS. The report renders just fine and exports just fine to all formats with the exception of csv! When exported to csv format, the first detail line is missing! The first line of ...more >>

Hi, Regardless of the set of data, I am finding that the report always ends with a blank page. I have tried several combinations of changing the KeepTogether parameter and have made sure the PageBreakAtStart = false and PageBreakAtEnd = false everywhere. What could cause this extra pa...more >>

I am putting the client name in my header using ReportItems! reference to textbox in report - this renders correctly on my server and in pdf however in excel the client name is not showing up on the report. There are 2 textboxes overlapping each other because I have 2 groups and when the page...more >>

Hi, I have listing with a few rectangles and one table in it. One two recetangles at top of page I have set the RepeatWith to be set to name of the table (table1). When the table spans multiple pages, I would expect that the two rectangles would be repeated at the top of the page. Th...more >>

Hi there, Does anyone know of third-party charting products that work with ReportViewer in local processing mode? I've looked at Dundas and ChartFX, and I'm waiting to hear back from their sales & support people, but from all outward appearances those two products only work with reports that ...more >>

Using RS2000 with SS2000. I'm coming in behind another developer and I have no experience with VS or RS. It looks like when the rdl file is uploaded into RS from the web site (I've read somewhere that there is also a way to deploy the report from VS), the rdl file disappears from the server...more >>

I have a production server running SQL Server 2005 Workgroup Edition ("SELECT @@version" shows: the text at the bottom of this post). On my test server which runs Developer Edition, I have created and tested 2 reports, both of which use the simple subscription features (one sends a single email...more >>

I have a report with a matrix in which I conditionally hide one of the data columns. This is working properly in preview on my development studio but when I deploy to the report server it is showing these hidden data columns when it is not supposed to - if I export the rendered report from ...more >>

I have a report which lists the city and state. The problem is that the city and state are in one field and were in Upper case. I used the strconv but I don't know how to make the state portion Upper instead or Proper. Right now the output looks like this: Birminham, Al Any help is appre...more >>

I am using SSRS 2005 and I have created a server report (rlc) in Visual Studio 2005. This report does not use tables, lists, matrixes, or charts. There is no grouping taking place. Instead I am just using textboxes bound to the fields in my dataset. I want to display a new page for each r...more >>

Has anyone ever successfully gotten a reporting services subscription (Delivery Method: Report Server File Share) to write a report to a sharepoint document library / unc path? We have been attempting this but keep getting the error message: "Failure writing file file.xls : The network path wa...more >>

hello, I'm creating reports for CRM. I have followed the steps exactly mentioned in the below link. http://www.microsoft.com/dynamics/crm/using/customizing/reporttutorial.mspx I have created my own view and tried the steps but i always get this error - this report cannot have a default filter...more >>

I'm trying to create a data-driven subscription with the ability to pass multiple values using a multi-select parameter. Is this possible, and if so how does one store the data in the database? Thanks, Josh...more >>

I'm trying to get hold of the data source(s) of a server report. I am running the report in the windows forms viewer control ReportDataSourceInfoCollection obj = objRepViewer.ServerReport.GetDataSources(); if (obj.Count > 0) { // never comes in here } im doing this check after the...more >>

Is it possible to print labels with Reporting Services? Thanks in advance. -- Albert Lyubarsky Comtec LTD Israel...more >>

Hi guys, I have requirement to show all the data from a table in a single page or minimum 100 rows in the first page . How it is possible. Please any body can solve my query. Thanks in advance. Shrinivas ...more >>

Hi, unfortuntely, MS has changed the logic of their generated Report HTML between RS 2000 and SSRS 2005 using the WEB RepotViewer control. In RS 2005 the generated HTML a) the values of parameter list are no longer the REAL report values - now it's only the collection id b) the name of ...more >>