Skip to Content

BOBJ Trick To Display Table Data In Hierarchy Format

This blog shows a small trick on how the table data can be displayed in a hierarchy format. As shown below, the first screenshot is a basic WebI report created on eFasion Universe. The second screenshot shows how the same data is displayed in a hierarchy format.

Pic1.png

To achieve this, first drag the State, City, Store name and Revenue into the report.

Pic2.jpg

Now create a Break on State Column with the following settings.

Pic3.jpg

Once the break is created, get rid of the unwanted blank and Total Columns. So, now your table should look like as shown below.

Pic4.jpg

Similarly create a break on the City and delete the unwanted rows as we did it for the State.

Pic5.jpg

Now select the top Column Cell and change the NameOf([Store Name]) to [State], so that it will display the State values instead of the Object name.

Pic6.jpg

Similarly do it for the City and Sales Revenue. Replace the Object name with the Values respectively.

Pic7.jpg

Now the first two columns are unwanted columns too. So we need to get rid of them. We cannot delete them because that will disturb the entire table structure. What we will do is hide them by removing the borders, making the text and background color as white. Also make the width of the Cell to 0.

Pic8.jpg

Inorder to make the values appear like hierarchy, we will put some space before City and Store Name. Also, we will do the formatting of the table by making the background color to white and removing the Bold from text and adding proper table/cell borders.

Pic9.jpg

So, now our table will look like as shown below.

Pic10.jpg

Right click on the table -> Select Table Format and tick the checkbox Show Table Headers.

Pic11.jpg

After adding the table header, we get the required hierarchy structure of the table.

Pic12.jpg

We can also add the background color to distinguish between the different levels.

Pic14.jpg

45 Comments
You must be Logged on to comment or reply to a post.