Discover a better way to add hierarchical data

The traditional way of adding sub-reports is cumbersome, does not scale well, and is a pain to maintain. Instead of having a single report, you end up with multiple reports that need to be synchronized.

We streamline everything. Here's how...

Adding a new level of hierarchal data is as simple as dragging and dropping a list and adding fields on top of it.

In the animation above, you can see that the report has more hierarchical data as the stack of lists increases.

This means;
  • No multiple reports to maintain
  • Straightforward workflow
  • Less memory footprint

What about parameters?

By default, primary keys are used as parameters in hierarchical data. Therefore, in most use cases, users don't need to take any action. However, users can use field values as parameters if they wish to. In such scenarios, all a user needs to do is go to the parameter edit dialog and pick and choose which combination of primary keys and field values to use as parameters.

Do you know that you can...

Attach as many levels of hierarchical data as needed in the Z direction?
This image shows that the Pixel Perfect Reports tool supports unlimited hierarchal data details. This is equivalent to supporting unlimited subreports in SSRS and other database reporting tools.

As an example, we can have a report that shows the sales performance of employees within a certain period with three levels of hierarchical data. The first level is the employee, the second level is the category sold by the employee, and the third level is the product within each category.

Click to see the report
Add as many details as needed in the X-Y direction?
This image shows that the Pixel Perfect Reports tool supports unlimited hierarchal data details at the same level. This means at each level of detail, you can add multiple lists, each broken down in detail using different parameters.

As an example, we can have a report that shows the sales performance of employees within a certain period with two levels of hierarchical data. The first level is the employee, and the second level is the sales breakdown by category, product, suppliers, and customers.

Click to see the report
Attach as many datasources as needed to a list?
This image shows that you can attach multiple databases to the same hierarchal data details.