Solved

ssrs 2008 print number of pages

Posted on 2013-02-06
6
600 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

690 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