DB Query: Order metadata and partlist on one label
Hello,
I would like to make a template for an order label.
The label header should contain order no., project name, customer name and delivery date. Below the header should be a partlist of the order.
This is a sample how the final label should look like.
I created a sql query to get this table.
What is the best practice to get the list below the header.
When I use normal text fields I get a label for every data entry.
Kind regards
Chris
-
I would suggest enabling the Page Template option from with the Page Setup > Setup tab and move all but the fields for the individual records to this new template that will appear. You will need to configure the size of the template area in the layout by increasing the margin sizes.
In the Database Setup window enable the records per item for how many you want to be able to appear on your label/report, again tweaking the “label size” for each page in the Page Setup
You should now see a template and a page template at the bottom of the screen. The template will where you configure the “label”for each record selected whilst the Page Template will have the header data.
0
Please sign in to leave a comment.
Comments
1 comment