Reports - How to avoid an empty row

We thought you might like to know how to avoid an empty row in the reports.

As an example I have here an Asset handover protocol for vehicles and office equipment. if I don’t have any office equipment assigned to an employee, I don’t want an empty row in the report.

Select the DataBand you want to set up, select Properties => Behavior => Enabled => Edit expression => and use a code of this type:
Transmission_processes_Equipment_Title_list.value != null && Transmission_processes_Equipment_Title_list.value != “”

Set the same for the vehicle and it’s done!

We hope you find this advice useful :slight_smile:
Thank you and have a beautiful day.

With kind regards,
Soňa

2 Likes