?
Solved

ssrs 2008 print number of pages

Posted on 2013-02-06
6
Medium Priority
?
605 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 2000 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

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

649 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