Docs  /  Excel Report Builder  /  Edit Evaluations  /  Tips & Tricks

 Output only if child records exist

2024/10/08 • 1 min. to read
Example A list of all customers for which customer ledger entries exist should be created. Customers that do not have customer ledger entries should not be included in the list. The list should output the number, name and balance of the customer. The trick in this case is not to output the fields directly at the customer level: The example can be downloaded in the Download Area. As you can see in this example, the first thing to do is to link the customer to the first customer ledger entry. After that the customer ledger entry will be linked to the customer again and the data of the customer will be output. As a result, only those customers are output for which a customer ledger entry is also found.