?
Solved

How to set total pages based on a parameter

Posted on 2010-01-11
3
Medium Priority
?
161 Views
Last Modified: 2012-05-08
I am working on a new report that prints custom 4x10 labels to a thermal printer. What I'd like to be able to do is pass the number of labels that need to be printed to the report as a parameter then create that many pages of the reprot. The query only returns one record because the labels are identical EXCEPT for the page number, so I can't just say print XX number of copies.
0
Comment
Question by:ticgums
[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
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
Auric1983 earned 2000 total points
ID: 26292315
ticgums,

Just curious, what value does the page number add to the report? Easy solution would be to remove the page num and use the copies :)

If you really must go down this road, you need to find a way to return XX number of records for SSRS to consume.  This would probably involve a stored procedure.

Pass parameters into stored procedure, populate temporary table w/ correct info and return to SSRS to use for printing.  
0
 

Author Comment

by:ticgums
ID: 26293112
I can't use the copies option to print because I need to show the page number on each label. So if I did 50 copies it would just say 1 on all of them instead of 1-50.

I had a feeling I would need to modify my stored procedure to create a row for each label. Sounds like this is my only option.
0
 
LVL 16

Expert Comment

by:Auric1983
ID: 26293545
Unfortunately, I can't think of any other option to accomplish this in SSRS.  
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

770 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