How to multiply records in CR

[KidCarson]

Hi,

can anyone help me by the following issue:

I'd like to print out some stics in CR. I get all the data for each item that I need into CR. One field is quantity - now I would like to print so many detail sections, as quantity (for example if quantity is 13, I need 13 sticks, that looks the same) . How could I do this?
Thanks

[jggtz]

The best approach, I believe, is to design & develop a small application to do it

[JaganEllis]

What's the maximum quantity?
If you can create a table in the database then create one with one numeric column and 'n' rows where each row has a quantity number in it. e.g.
create table multiply(quantity number);
insert into multiply values (1);
insert into multiply values (2);
insert into multiply values (3);
etc.

and then join to this table on the quantity fields using a >= link, e.g.
select t.field, t.quantity
from table t inner join multipy m on t.quantity >= m.quantity
order by t.field

This'll give you 'quantity' detail records per item. The only problem I see is that items with a quantity that's greater than the maximum number in the multiply table will only have that maximum nuber of records.