Serializing When Db Field Changes

Legacy Poster

• October 31, 2013 17:32

I need to serialize my labels but I need to reset to 1 when the field change ( My Db could have more than 1 record for the same field). I tried OnNewRecord option but it always goes to 1 since is a new record..

 

i.e 

 

Record   SalesOrder                label should be like:

1                  123                           box 1 of 3

2                  123                           box 2 of 3

3                  123                           box 3 of 3

4                  678                           box 1 of 2

5                  678                           box 2 of 2

6                  777                           box 1 of 1

7                  999                           box 1 of 1

 

but My logic does not reset the initial number to 1...

 

How can I achieve this ?  I'm using 8.01

 

Thanks masters

0

• 

  Michael Toupin (mtoupin

  ★ BarTender Hero ★

  • October 31, 2013 18:08

  This functionality was introduced in BarTender 10.1.  In the 'reset' tab, you'd check the box for 'data changes', then specify the field.

   

  To do it in VB scripting it's a bit more complicated.  What you have to do is to create a variable, then on print start assign the database field to it.  

   

  So OnPrintStart do:

   

  Counter = Field(databasefield)

   

  Then OnNewRecord do:

   

  If Counter <> Field(databasefield) then 

  value  = 1 

  Counter = Field(Databasefield)

  end if

   

   

  so that it only resets if the database info is different than the previous info.

  0

Please sign in to leave a comment.