Label Report
I would like to have a parameter on a packaging label report where the user can enter how many labels to print. This parameter should then determine how often to repeat a list. In the list I want to have a textbox saying on the first label for example "1 of 5", the second label should say "2 of 5" and so on. How do I do this?? Any help would be greatly appreciated.
July 24th, 2011 10:52am

One idea that comes to mind is to use a subreport in a matrix/table. If the matrix/table is bound to a query that accepts an integer parameter, and returns a number of rows equal to the integer passed in, what you will get is the subreport repeating that number of times. The subreport could be the label you wish to print, and it could accept the integer field from the query above as a parameter, allowing you to print = "Label 1 of " + Parameters!IntegerParam.Value Hope it helps.
Free Windows Admin Tool Kit Click here and download it now
July 24th, 2011 9:05pm

Great idea! Thanks for that. I created a table where I get the same amount of rows back as the number the user entered. I attached the query to a list and it gets repeated as often as the number entered.
July 28th, 2011 5:55am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics