Does anyone know how to create a Word Report where I can dynamically create pages based on a user populated field. I want a Box Label where the user enters the number of labels they need. I was thinking to use the Integer table...
Word layout reports are basically not very dynamic and you cannot make any formulas or alike.
But as long as you can do all the "logic" in the report, then it should be possible to do. And if you have your "box header" and Integer table (as you write) as the report dataitems, where the integer element is repeated for as many time as the user request it. I think you can find examples on label reports created like that in the standard reports.
If you are printing to a "true label printer", and prints 100's of labels everyday, then it could make sense to looking to a more advanced solution, like RichLloyd suggests.
I was able to achieve this using the Word Layout. I used the Integer Table as my first dataitem.
Then on the word document I created a 4 x 6 page, inserted a table in the word doc with only 1 cell. This table is the full size of the page.
I then inserted a repeater in the table which is linked to the Integer dataitem.
The report has a 1 parameter to get the number pages required. I then set a filter to the Number table based on the number of pages required.
It wasn't easy to do and get it working but once you figure it out, it makes sense.