Solved

ssrs 2008 print number of pages

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS - Powershell 7 80
Display Date and Time 7 48
Server 2012 r2 and SQL 2014 6 34
Moving away from Access 2003 adp files 4 46
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…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

734 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