I'm using VS 2008 reporting services to building page that will print barcode labels with some data fetched from the database. The labels are on a standard 8.5x11 sheet with 3 across and 10 down. The rdlc file only has the first row of 3 labels and depending on the data, many sheets can be printed.
Everything works fine except one thing: I want to be able to reuse a sheet of labels that have unused labels on it. For example if I print one full sheet of labels (30 in total) and another sheet of 7 labels. I'll have 23 unused labels.
On my next print job I want the report to start printing on the label number 8 rather than number 1. The report parameter already contains an integer that corresponds to this new position (which the user will enter on previous page), but here is where I need help with the logic.
Presently, in the List Properties of each of the three labels there is an expression like this:
for position 1: =iif(RowNumber(Nothing) mod 3 = 0, false, true)
for position 2: =iif(RowNumber(Nothing) mod 3 = 1, false, true)
for position 3: =iif(RowNumber(Nothing) nod 3 = 2, false, true)
In addition, I printed out the row number for test purposes on each label and they print incrementally from 1 - 30, starting from left to right, and top to bottom. So there is some consistency that may be used.
Is anyone familiar with what I want done. I'm quite sure this has been done before. Thanks in advance!
EJM