Hierarchical Band aggregate functions

patwolf · Post by **patwolf** » Thu Jul 10, 2008 2:08 pm

Hi,

I have a hierarchical report and would like to calculate & display sums, counts etc. in the following way:

A Type: P                                   (Count T = 3),  (Count C = 4), (Count S = 2)
.A1 Type: S                                (Count T = 3),  (Count C = 3)
..A1-1 Type: C                            (Count T = 2)
..A1-1-1 Type: T
..A1-1-2 Type: T
..A1-2 Type: C
..A1-2-1 Type: T
..A1-3 Type: C
.B1 Type: S
..B1-1 Type: C

As you see every row has a Type property (P,S,C,T) which the aggregate function (count, sum etc.) would be based on.

Thanks a lot,
Patrick

Post by **Vital** » Sun Jul 13, 2008 6:56 pm

Hello Pat,

At this moment you can create different totals for different levels of HieararchicalBand.

Thank you.

patwolf · Post by **patwolf** » Mon Jul 14, 2008 1:36 am

Cool how would I do it please?

Thanks,
Patrick

Post by **Edward** » Mon Jul 14, 2008 6:13 am

Hello, Patrick.

Yes, we had plans about implementing some new features in calculating of HierarchicalBand's totals. But we are not ready to include these improvements in today's build, because still some fixes are necessary for it.

Also there was another question and suggestions from you about Hierarchical band.

We are working on them right now and by the end of this week we will complete some steps in that direction. Hierarchical Bands really needs to be improved and thank you very much for those your suggestions and sorry for the delay.

If you have maybe some new thoughts about work with Hierarchical band, please share them with us, because a fresh good idea would be to the point right now.

Thank you.

patwolf · Post by **patwolf** » Thu Aug 07, 2008 4:46 pm

Edward wrote:Yes, we had plans about implementing some new features in calculating of HierarchicalBand's totals. But we are not ready to include these improvements in today's build, because still some fixes are necessary for it.

How are you going with this as it's an important feature for us.

Edward wrote:If you have maybe some new thoughts about work with Hierarchical band, please share them with us, because a fresh good idea would be to the point right now.

I do I just need some time to sit down and write them down. Hope to do this soon.

Thanks,
Patrick

Post by **Vital** » Fri Aug 08, 2008 5:51 am

Hello Patrick,

We already release this functions, but need some time to fix some bugs. I hoope we release build with hierarchical totals in next Monday.

Thank you.

patwolf · Post by **patwolf** » Fri Aug 15, 2008 4:19 pm

Vital wrote:We already release this functions, but need some time to fix some bugs. I hope we release build with hierarchical totals in next Monday.

How can I use the aggregate count function in the new version please (see sample above)?

Thanks,
Patrick

Post by **Edward** » Mon Aug 18, 2008 2:29 am

Hello, Patrick.

We did not include this new functionality in the Monday's build. I believe it will be done in the build from Wednesday.

We are on the way of adding of two new properties to the Hierarchical Band: 'Headers' property and 'Footers' property.

Appropriate headers and footers of the Hierarchical band could be assigned to these properties.
Assigning them to the Hierarchical band means using them for each level of Hierarchy.
So those aggregate functions which you showed in your sample will work as they should.

Thank you.

Post by **Edward** » Thu Aug 21, 2008 4:22 am

Hello, Patrick.

We need a half a day more for completing solution with aggregate functions in the Hierarchical band. The release will be available today in the evening.

Calculation of the aggregate functions will have the following syntax:

Code: Select all

{Totals.Sum(HierarchicalBandName,expression)}

Thank you.