<div>
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.<br />
<br />
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. 
</div>


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.

<div>
Unfortunately, I can't think of any other option to accomplish this in SSRS. &nbsp;
</div>


Unfortunately, I can't think of any other option to accomplish this in SSRS.  

<div>
<div class="content wysiwyg-content">
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.
</div>
</div>


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.

How to set total pages based on a parameter

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.