Page 1 of 1
Hierarchical Band aggregate functions
Posted: Thu Jul 10, 2008 2:08 pm
by patwolf
Hi,
I have a hierarchical report and would like to calculate & display sums, counts etc. in the following way:
Code: Select all
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
Hierarchical Band aggregate functions
Posted: Sun Jul 13, 2008 6:56 pm
by Vital
Hello Pat,
At this moment you can create different totals for different levels of HieararchicalBand.
Thank you.
Hierarchical Band aggregate functions
Posted: Mon Jul 14, 2008 1:36 am
by patwolf
Cool how would I do it please?
Thanks,
Patrick
Hierarchical Band aggregate functions
Posted: Mon Jul 14, 2008 6:13 am
by Edward
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.
Hierarchical Band aggregate functions
Posted: Thu Aug 07, 2008 4:46 pm
by patwolf
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
Hierarchical Band aggregate functions
Posted: Fri Aug 08, 2008 5:51 am
by Vital
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.
Hierarchical Band aggregate functions
Posted: Fri Aug 15, 2008 4:19 pm
by patwolf
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
Hierarchical Band aggregate functions
Posted: Mon Aug 18, 2008 2:29 am
by Edward
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.
Hierarchical Band aggregate functions
Posted: Thu Aug 21, 2008 4:22 am
by Edward
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.