Solved

ssrs 2008 print number of pages

Posted on 2013-02-06
6
590 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

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.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

757 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

19 Experts available now in Live!

Get 1:1 Help Now