| Author |
Topic |
|
Dutchie75
Starting Member
22 Posts |
 Posted - 2010-01-05 : 13:23:24
|
| I've created a label report in Visual Studio 2005 (Avery labels on 8.5 x 11 inch paper)... looks good. The report will likely only print one or two labels at a time, so now I want to add a feature that enables the user to choose which label on the sheet to start on, so that a new page doesn't have to be used each time. I've done this successfully in Microsoft Acess using a similar method to this link: http://msdn.microsoft.com/en-us/library/aa140106(office.10).aspxI can't figure out how to accomplish this here. Insight? Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-06 : 04:02:56
|
| you can select images dynamically by writing an expression for value property of imagehttp://www.mssqltips.com/tip.asp?tip=1355 |
 |
|
|
Dutchie75
Starting Member
22 Posts |
Posted - 2010-01-06 : 10:43:32
|
| will this work for a mail merge? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-06 : 11:20:52
|
quote:
Originally posted by Dutchie75
will this work for a mail merge?
what do you mean by mail merge? |
|
|
|
Dutchie75
Starting Member
22 Posts |
Posted - 2010-01-06 : 11:40:07
|
| I'm accessing a dbase of clients that we need to send letters to. I've created the label report based on a query for those selected clients (one client per label) with the following fields:NameAddressTown, Province PostalCodeSo as not to waste paper/labels, I want to be able to choose which label on the sheet to start printing on. For example, I've already used 3 labels on the sheet of label paper. So I want to be able to choose to start printing on label 4 the next time. Make sense? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-06 : 11:51:45
|
| yup. then its just a matter of generating rownumber for labels and include a parameter in report to determine what label onwards you need to print. then in report filter on passed parameter value to return only labels >= passed value |
|
|
|
Dutchie75
Starting Member
22 Posts |
Posted - 2010-01-06 : 12:04:54
|
| I'll give a shot later today. Thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-06 : 12:09:06
|
| ok..let us know how you got on |
|
|
|
Dutchie75
Starting Member
22 Posts |
Posted - 2010-01-07 : 15:09:07
|
| visakh16 - I apologize. I've only just now started looking at this. I'm going to keep playing, but in the mean time, can you elaborate a little more... "generating rownumber for labels and include a parameter in report to determine what label onwards you need to print. then in report filter on passed parameter value to return only labels >= passed value"... I think I understand the parameter part clearly, but how do I generate a rownumber for each label? |
|
|
|
Dutchie75
Starting Member
22 Posts |
Posted - 2010-01-07 : 15:09:59
|
| also... what would the syntax be to start printing a particular rownumber? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-08 : 02:41:29
|
quote:
Originally posted by Dutchie75
also... what would the syntax be to start printing a particular rownumber?
there's a rowumber function available in ssrs. i assume you're generating labels inside a list/table.if yes add a new column and give expression as =rownumber(nothing) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-08 : 02:44:35
|
quote:
Originally posted by Dutchie75
also... what would the syntax be to start printing a particular rownumber?
its just a matter of adding filter to table/list as=Rownumber(nothing) > = =Parameters!yourparameter.value |
|
|
|
|
Avery Label Report - how can I choose which label?