HierarchicalBand Question

[rover]

Hello!

I'm working with HierarchicalBand right now and I need to show the number of records at each level of the hierarchy.

I'm using expression like {CountIf(HierarchicalBand1,Group.ClassTypeID == "T")}, where Group.ClassTypeID == "T" is a condition of including each particular record in the count.

But I've got the same results for all levels of hierarchy - the results oh highest level.

Here is an example.

I've got data structure like: Container - Box - Piece. E.g. there're boxes in container, and pieces in boxes.

I have to show an amount of pieces in each container, in each box etc. But I always got an amount of pieces in container, even at box level.

What should I do? And are there any help or description of HierarchicalBand component?

Thank u.

PS. Answer in Russian is acceptable, I've just don't have Cyrillic keyboard at work:grinder:

[Edward]

Hello.

Please see the report in the attachment. You have to open it in the Demo sample application which comes with a standard installation of Stimulsoft Reports.Net.

'Headers' and 'Footers' properties of Hierarchical band allows to connect other headers and footers to Hierarchical Band.

There are samples on calculating of Count and Sum Functions in the report. Calculation of CountIf function has been made with a trick. One expression contains Sum function and ternary operation.

Код: Выделить всё

Count: {Totals.Count(HierarchicalBand1)}
Sum: {Totals.Sum(HierarchicalBand1,Employees.EmployeeID)}
SumIf: {Totals.Sum(HierarchicalBand1,Employees.Country == "USA"?Employees.EmployeeID:0)}
CountIf: {Totals.Sum(HierarchicalBand1,Employees.Country == "UK"?1:0)}

These features will work in Engine_V2 with prerelease builds which have been issued during last two weeks.

http://forum.stimulsoft.com/upload/hier ... 2008_2.zip

And there is also another feature available with HierarchicalBand1.PrintOnAllPages = true settings.

In that case hierarchical band repeats all its last records from the higher levels starting from the first node on each page of the report. Just increase the size of hierarchical band in that report and you will see this property 'in action'

Thank you.

[rover]

Hi!!!
I've tried ur solution, but it doesn't work 4 me. All counts count only the first level items on each level of hierarchy, but I need 2 count all the way through.

For example, imagine folder tree at the disk like this:

Код: Выделить всё

ROOT
|
|__A1_
|     |__B11_
|     |      |_111.txt
|     |      |_112.txt
|     |      |_113.txt
|     |
|     |__B12_
|            |_121.txt
|            |_122.txt
|            |_123.txt
|          
|__A2_
|     |__B21_
|     |      |_211.txt
|     |      |_212.txt
|     |      |_213.txt
|     |
|     |__B22_
|            |_221.txt
|            |_222.txt
|            |_223.txt
|        
|__A3_
      |__B31_
      |      |_311.txt
      |      |_312.txt
      |      |_313.txt
      |
      |__B32_
             |_321.txt
             |_322.txt
             |_323.txt

I'd like 2 now the amount of files in the root (which is 18 !!!!), the amount of files in each Axx folder (which is 6 !!!!), the amount of folders Bxx in the root (which is 6 !!!!) or the amount of folders Bxx in each Ax (which is 2 !!!!) and so on, but report engine doesn't go into. Are there any solutions of this problem?

Thank u 4 ur patience.
Pavel

[Edward]

Hi, Pavel.


Yes, there is a solution exactly for this report I added the link in my previous post. But this will work only in prerelease builds we have released during last two weeks.

Please send your report to support[at]stimulsoft.com and we will help you.

Thank you.

[Vital]

Hello,

We have added special postfix to all total functions. So you can use functions as:

Код: Выделить всё

Totals.SumAllLevels(HierarchicalBand1, expression)

Modifications will be available in build from 18 September.

Thank you.