alas, it doesn't work that way. CR prints the number of records that it sees. If it sees 3 records, it will print 3 records. You might be able to suppress the printing of a record, but you would need to know which record you are on, since you do want the first 2 records to print. If CR is printing short (you need 3 but CR is only producing 2 records) there is very little that you can do.
Using a stored proc allows you better control over the number of rows needed. You can also try joining the values to table of numbers...
Say you have a table that looks like:
1
2
3
4
5
6
7
you can create a command object that does something like:
select * from tableWithInfo Full join numberTable
where numberTable.value <= tableWithInfo.numberOfLabels needed
This will multiply the number of records that you need to the proper amount, then CR will print 1 label per record.
HTH
IP Logged
