Design Header/detail Based On Datasource

Legacy Poster

• 1. Februar 2012 06:23

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.

0

• 

  Legacy Poster

  ★ BarTender Hero ★

  • 1. Februar 2012 16:38
  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
• 

  Legacy Poster

  ★ BarTender Hero ★

  • 4. Juni 2013 16:01

  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.

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.