how to calculate conditional sum in devexpress xtrareport

c# xtrareport
kashif picture kashif · Oct 14, 2012 · Viewed 18.1k times · Source

Consider my following XtraReport

enter image description here

It generates following output when previewed.

enter image description here

Notice the sum of Total marks in the report footer i.e 125. My Question is: How will I calculate the sum of the only fields where result is p. Thus in this case sum of TotalMarks should be 75.

Answer

kashif picture kashif · Oct 24, 2012

I found its solution by adding a calcultedfield and assigning

Iif([Result]='P',[TotalMarks],0 )

in expression editor.

Related questions

How to set datasource for fields in XtraReports without having a dataset at design time?

I'm taking a look now to XtraReports reporting tool and there's something that I don't get it yet. How do I set the data source for a certain field (showed in the report as a Label I guess), without having …

Read More
DEVEXPRESS - xtrareport - page break

I have a datatable with more than 300 rows. I want each page to present only 10 rows in it. I want to force the xtrareport to break after 10 rows. Any idea on how this is done ?

Read More
How can I serialize a DevExpress XtraReport report design

I need to serialize a report design. This is the scenario: The app has base reports, let's say "Sales Report" with a set of pre-defined columns and design, like the corp. logo in the header. The users needs to have …

Read More