Print to Avery Labels Sheet

[mchapman]

I am trying to support printing to a sheet of Avery Labels. I can print to the sheet correctly with labels showing up where I need them to. However, I need to support printing to a partial sheet by skipping labels. If the user chooses to skip 5 labels then the printing needs to start form the 6th label.
I've created a user entered variable where the user tells me how many labels to skip. I can then use this in a condition to disable a panel until the desired number of labels have been skipped, great. However, once I reach the label where I need to start printing I need to reset the datasource position back to the beginning. This is the part I am struggling with. I've tried using the following line of code in several different events in my DataBand, but I cannot get it to work.

IIF(Line == LabelsToSkip, vItemCategoryManufacturer.Position = 0, null)

If I put this in any of the rendering events, nothing happens. If I put this in the Before Print event the position is reset back to 0 as I expect, but then never increments again.

[Lech Kulikowski]

Hello,

Please check the sample report.

Thank you.