Post reply

Counting for Labels

  • March 11, 2013 at 7:18 am

    #394351

    I am running all of my production labels using SSRS 2008R2

    I am trying to constuct a label that will Print x number of labels based on a parameter.

    For example, If a user wishes to print 5 labels starting at #1 they would select a start parameter value of 1 and an End Parameter value of 5.

    The report would then Print 5 labels.

    At the same time I would like to display 1 of 5, 2 of 5, etc... on each label.

    Anybody have any suggestions? This one has me a little stumped!

  • March 12, 2013 at 6:08 am

    #1595935

    What about filtering the dataset or the tablix using the Top N values.

  • March 12, 2013 at 6:52 am

    #1595964

    The issue isn't so much with the query. The query only returns one record. This is probably a newbe issue but what I am trying to accomplish is simply to have the identical label print with 'Box 1 of 4' , 'Box 2of 4' etc...

    Unfortunatly, I have not been able to figure out first how to print multiple labels from a single query yet.

    Much less add the counts to the label.

  • March 12, 2013 at 7:13 am

    #1595986

    Not sure how you can get from one row to multiple labels other than passing a the count to the query. You could also potentially use the row number function once you get the correct number of rows.

  • March 12, 2013 at 8:23 am

    #1596040

    Jeff Moden has some articles here on Tally tables.[/url] You could make a tally table with N rows in it (N being a Parameter passed to the query like Scott suggested) and join that table to your original table.

  • March 14, 2013 at 9:36 am

    #1597090

    Thanks for the help guy's!

    I now have my query returning x records based on the parameters, with a field (N) containing the count that I need.

    fro example if the user select to start @ box 1 and print 5. The query returns 5 records with a field that contains 1,2,3,4, and 5 respectively!

    Now the next part of the same issue.

    How do I get the report to generate for each individual record? In the case above I would want it to have 5 pages to the report with the first one having a 1 for field (N), the second having a (2), etc...

    I know it can't be too difficult and I am missing something basic.

    Again, thanks in advance for the help!

  • March 14, 2013 at 9:45 am

    #1597100

    I would set the page size to your label size, and then group on the N values and tell the group to page break between each group.

  • March 14, 2013 at 1:14 pm

    #1597216

    thank you for all of your help. I have it working now.

    What I had to do is create a list and put all of the fields inside the list.

    I added a page break after the list and it works great!:-D

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply