Design Header/detail Based On Datasource Follow

0
Avatar
Legacy Poster

I have one query which has 1:m relation on it and I need to print individual pages for each and every detail data. For an example, I will have multiple items under one code and again multiple detail records under another master code. So I want to print master code in first page and then details code start from next page, after finish tht master code, it will print next master code and then detail code so and so on. I will have two different design for master code and detail code. Please see the attached to get an idea, also see the below records which will have in my data source.

[MasterCode] [ItemCode] [Qty]
MCode1 Item1 10
MCode1 Item2 14
MCode2 Item3 12
MCode3 Item2 22
MCode3 Item1 11

Please guide me how to design the labels based on my requirements or any tutorial highly appreciated.

2 comments

0
Avatar
Legacy Poster
Comment actions Permalink

Even if we just focus on column A, the Master Code, we have an issue. You're basically asking the software to print the data in this column only if the data has changed from the previous row (because you only want one page that says "MCode1", when there are 2 records with it present). No such check exists that I know of.

In my opinion, the easiest solution is going to be going back to your data-file and re-designing it based on how Bartender reads your data, which is one row of data per label. Therefore, your data would end up something like:

[Master/Item Code] [Qty]
MCode1
Item1 10
Item2 14
MCode2
Item3 12
MCode3
Item2 22
Item1 11


After that, depending on how different your two designs are, you may be able to do some VBS suppression of certain fields to get the results you need.
0
Avatar
Legacy Poster
Comment actions Permalink

I had an application where I needed to print shippling labels similar to your concept. 1 pallet label, then all the carton labels that go on that pallet, then the next pallet label, etc.

I found no way to do this in the version of BTE we have, so I ended up just designing a label format in BT, and then streaming label data files to commander from a SQL Stored Procedure. That way I was able to process the data any way I wanted and then plug it into the label design one at a time. Works really well - have printed many thousands of labels this way.

Please sign in to leave a comment.