Displaying data is one of the key points in creating reports. This article will show you several ways to output data, give some practical recommendations, and provide samples to show convenient ways to output data.

Specifically, we will talk about creating lists of data, but not about calculations in reports, displaying graphical data, filtering, or conditions. Today we are interested in how to create lists and the components with which they are created. Let's get started.

Data lists

Let's start with lists. They can be:
  • Simple. Data from the source is displayed in the report line by line;
  • Hierarchical. In this case, the data is also displayed line by line but keeping its original hierarchy;
  • Cross-lists. Display data from the source by columns or by columns and rows.

Report sample with different lists


Naturally, these are not the only ways to design reports. Even with the basic skills, you can build any reports practically without restrictions.Well, let's go back to the lists. We will analyze them in more detail.

Simple list

You may create it using the Data band or the Table component. If you use a band, you should place text components with links to data columns on it, and if you select a Table, you should specify the links in its cells. Learn more about creating lists using the Data band and the Table component.

By the way, a simple list can be displayed using the Cross-Table component, but let's not go there.

Hierarchical list

It is called so because the Hierarchical band is used to display the data hierarchy within one source. Once again - we are talking about hierarchical subordination within one data table. If you are interested in the hierarchy between tables in a report, wait for our next article. In the meantime, you can find detailed instructions on creating hierarchical lists here.

Cross-list

It is a type of data output in which each data source entry is displayed in the report as a new column. Accordingly, a special Cross-data band is used to display cross-lists. If the list should be displayed once, it is placed on the Data band with a virtual source equal to 1. For more details, watch the related video.

You should know this!

The Cross-tab component is quite popular among our clients because it allows you to display data by rows and columns. Step-by-step instructions on using cross-tab in reports you may find here and here. Lifehack - using the Cross-tab component, you can simulate the displaying of simple lists or cross-lists. Just do not specify columns or rows for this component, respectively.
Basically, this is all that we wanted to tell you about creating lists for displaying data in reports. If you have any questions or concerns, please get in touch with us. We will be happy to help.