Filtered Subtotals

[Jonathan]

I'd like to subtotal  items based on a boolean field in the datasource that is not being grouped on.  So my subtotal would look like:

= Sum(Fields.DemandAtMemberPeak) where Fields.Include = 1

if this were indeed the correct syntax.  It doesn't run and the sub-report just shows a a red box.  How would I create a subtotal that filters on another field in the datasource?

Thanks Much

Jonathan

[IvanDT]

Hello Jonathan,

In Telerik Reporting you can use in the Expressions not only Aggregate Functions but also Functions and User Functions. We are suggesting to you to check our online help in order to get more information about the topic and especially for IIf function which can help you in your case. You can check the following articles:

• Expression Scope;
• Using Expressions;
• Developer's Reference;
• Extending Expressions.

All the best,
IvanDT
the Telerik team