Excel several lines per label
Hello everyone,
I have been approached with a requirement that I don't know whether it will work at all and, if so, how I can implement it.
Initial situation: employees are exported from a software. The export takes place as an Excel file. Each employee has access rights for at least one or a maximum of six areas. A label is to be printed for each employee, on which the respective permitted areas are listed.
Unfortunately, the export does not take place per employee per row, but a new row is exported for each access area.
Example:
In Excel, for example, this can be displayed as a pivot table.
But how can I do this in Bartender? Unfortunately I have no idea and would be grateful for any help!
I am using version 2022 R8 Automation
-
In the Database Connection Setup adjust the Records per Item to suit your requirements. I set mine to 5 in the image below, and then add on the appropriate fields to the label, I used Nummer and Name and Berieich and 2-5 for this test
0
Please sign in to leave a comment.
Comments
1 comment