Bottle Cap Belt Bb Simon

Problems with Hierarchical Reporting in Crystal Reports 2008

here again for sharing something I find very useful when creating reports of this kind, often spend many times that we organized our data in a hierarchical manner, such as organizational structure of a company.

The way to create this kind of reporting is very simple, I'll show an example with the following data table:

As you can see we have the column structure would become the key to the registry and PEstructuraID column would become the key to the parent record upon which that record, which has NULL values \u200b\u200bare the following records or parents.

Now create a report that working with this table and grouped by structure as shown in the image

At the end of our report, we will be like this

So far there has done nothing special, but to create a simple report grouped now proceed to give a hierarchical structure, with an option that comes in Crystal Report menu-> Hierarchical Grouping Options:

Selecting this option prompts you to indicate the column that contains the parent record key and bleeding to apply for the sublevels:

automatically

And with that we will have a report with hierarchical structure as they wish, and there may be adjustments to the respective design to make it show whatever you want.

this contribution I hope they can certainly also works in Crystal XI.

Greetings!