ok, this is a slick trick that someone posted here. The part that i don't know about is building the table. We have one in our DB, the poster had it in Excel or Access or something as I don't recall....
you have a table that is just numbers 1 to 1000 let's say.
You join your location to the numbers table based on your formula. In SQL this is easy, in CR, you would need to use a command that would give the location and the number of labels desired, then join this to the numbers table.
so you have the table with location
joined to command with the location and the number of label (on the location)
joined to a table of numbers where the number <= (to the function value of the last command) [this is how you get the multiple rows]
should work, the hard part is the numbers table, and that can be brought in from Excel and looks like:
1
2
3
4
5
6
7 etc
HTH
IP Logged
