Trying to calculate the Average of the non zero rows in a column in an RDLC

Posted by Eric Brown - Cal on Stack Overflow See other posts from Stack Overflow or by Eric Brown - Cal
Published on 2010-05-24T20:01:44Z Indexed on 2010/05/24 20:11 UTC
Read the original article Hit count: 324

Filed under:

reportviewer

|

rdlc

|

reportviewer2008

Is there any way to caculate the average of the non zero rows only for a column of data in a table in an RDLC for Microsoft report viewer?

ie 0 0 0 5 5 = 5 not 2

I tried Count( fields.n.value > 0 ) to get the count of non zero rows, but it returned the count of all rows.

Thanks!

Eric-

© Stack Overflow or respective owner

Related posts about reportviewer

Using ReportViewer 9 control in VS 2010

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am writing an ASP.NET app that uses a SQL Server 2005 with SSRS setup. I want to use the ReportViewer control but I get an error when using ReportViewer 10 because it needs SSRS 2008. How can I use ReportViewer 9 within my application. I've added a reference to the Microsoft.ReportViewer… >>> More
c# WinForms ReportViewer Performance issue using RefreshReport() and ServerReport.SetParameters()

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, Currently I am writing a c# client application that uses the WinForms ReportViewer Control to display reports from a remote server. I am having performance troubles with the ReportViewer Control, to be specific with the 2 methods reportViewer.ServerReport.SetParameters() and reportViewer… >>> More
Crystal Reports Reportviewer - Set Datasource Dynamically Not Working :argh:

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm running CR XI, and accessing .RPT files through a ReportViewer in my ASP.NET pages. I've already got the following code, which is supposed to set the Report Datasource dynamically. rptSP = New ReportDocument Dim rptPath As String = Request.QueryString("report") … >>> More
ASP.NET Session does not timeout on using ReportViewer Control.

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, We are using the ReportViewer control to display SSRS reports in our ASP.NET application. On pages where we use the ReportViewer control the session does not time out. The reason for this is the ReportViewer control emits a "setTimeOut" javascript function which reads the Session timeout value… >>> More
The Low Down Dirty Azure Blues

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Remember the SETI screen savers that used to be on everyone's computer? As far I as know, it was the first bona-fide use of "Cloud" computing…albeit an ad hoc cloud. I still think it was a brilliant leveraging of computing power. My interest in clouds was re-piqued when I went to a technical… >>> More

Related posts about rdlc

Reporting Services 2010 RDLC: Passing Querystring Parameters from an RDLC

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to build a simple RDLC report that shows some data, and has a 'select' link that sends the browser off to a certain url with some data in the querystring (a key). In the vs2010 report designer, I can double-click on the column, then select action, and there are a bunch of thigns that… >>> More
dynamically setting the size of a textbox in a RDLC report

as seen on Stack Overflow - Search for 'Stack Overflow'
Can a textbox's width in a local RDLC report be set dynamically using C#? I would like to auto size the horizontal width of the text box based on the data it contains. >>> More
Problem sub-total Matrix with rdlc report in vb.NET

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi everyone, I have a matrix and I need to add the money earned this year and past years. However, I must remove the money spent in past years. I must have the separate amount per year and the total of these amounts. This is what gives my matrix: Year = Fields!Year.value =formatnumber((sum(Fields… >>> More
When to use RDLC over RDL reports?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have been studying SSRS 2005 / 2008 in the past weeks and have created some server side reports. For some application, a colleague suggested that I look into RDLC for that particular situation. I am now trying to get my head around the main difference between RDL and RDLC. Searching for this information… >>> More
RDLC - Adding a Data Source in VS2010

as seen on Stack Overflow - Search for 'Stack Overflow'
Greetings. I have an RDLC file and am wanting to add a data source to it, although without any luck so far. The data source is a custom class written by myself (just to add, we do this all the time). We recently converted over to the VS2010 RDLC format which caused some problems, but we've made… >>> More