Group Sums / Aggregates part duex

[Mark]

Hi All,

I have the general group aggregate processes working so I understand the concept.  What I need on the report, however, is a bit more complicated.

I have the following logical grouping:
Labels
    Field.PropertyA
        Field.PropertyB

I aggregate PropertyB with values in a textbox in the group as: = Sum(Fields.quantity* Fields.convPounds)
This produces two logical group per PropertyA as there are two possible values for PropertyB.

At the footer of the report, I'd like to present the total aggregates of the two PropertyB groups.

The sample provided gives us generic grand total without any differentiation which is something I'd need to carry to the end.  So in the report footer I'd have something like:

    "Net total PropertyB.Type1" = SUM()
    "Net total PropertyB.Type2" = SUM()

Help is appreciated.

[Steve]

Hi Mark,

Have you tried using the Data Scope Related Functions with the specific groups as first argument and the aggregate as second?

All the best,
Steve
the Telerik team

[Mark]

Hi Steve,

Thanks very much for the direction this will certainly sort it.

Mark

[Mark]

Hi Steve,

I guess I spoke too soon.  I spent some time reviewing the documentation and testing the logic, and if I understand it correctly basically I can target a group, but I can't differentiate the group.  As you see from my description, I need to aggregate each "PropertyB".  I've tried unsuccessfully using logic like exec(Field.PropertyB='apple', sum(field.quantity * field.pounds).

I also had a look at the User Aggregate Functions.  I was wondering if a sample was available that utilizes this approach.  I looked at the included and didn't see it in action.  Perhaps this might provide what I need.

If you have a small sample of it that would be terrific, or any other advice.

Thanks as always.
Mark

[Steve]

Hi Mark,

I guess using expressions like this is what you are after:

"Net total PropertyB.Type1" = Sum(IIf(Fields.PropertyB = "Type1", Fields.quantity* Fields.convPounds, 0))
"Net total PropertyB.Type2" = Sum(IIf(Fields.PropertyB = "Type2", Fields.quantity* Fields.convPounds, 0))

Regards,
Steve
the Telerik team

[Mark]

Hi Steve,

Thanks as always.  This looks like it will suit me perfectly.
I appreciate you continued support very much.

Mark