Solved

ssrs 2008 print number of pages

Posted on 2013-02-06
6
592 Views
Last Modified: 2013-02-11
I created a report that generates pallet tags and it generates one tag per record.  what I want to do is pass a print quantity per record. for instance the order quantity is 60 cases and pallet quantity for this item is 30 cases per pallet so I want to print 2 pallet tags for this record.  how do I tell ssrs to print 2 tags for this record?

thanks
0
Comment
Question by:bobk207
  • 3
  • 2
6 Comments
 
LVL 6

Accepted Solution

by:
liija earned 500 total points
ID: 38861168
Interesting problem. SSRS is not that good in handling page breaks and copies.
I think you have to combine two things.

First, you have to handle the quantity of required copies inside our SQL. Populate the order rows to match the required print quantity. Use this method:
http://www.kodyaz.com/t-sql/repeat-rows-according-to-column-value.aspx

With the populated rows you can group your data - inside table - with the order no and running count per order, that you get from the populate rows method. In SSRS you can define page breaks per group in tables. Other option is to use sub reports.
0
 

Author Comment

by:bobk207
ID: 38873619
I liked your solution for printing multiple pages per item

thank you
0
 

Author Comment

by:bobk207
ID: 38873695
I've requested that this question be closed as follows:

Accepted answer: 0 points for bobk207's comment #a38873619

for the following reason:

i didn't
0
 
LVL 6

Expert Comment

by:liija
ID: 38873696
Don't understand the reason for the close request.
0
 

Author Closing Comment

by:bobk207
ID: 38876073
thank you
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now