This is one of those little used 'tricks' of SQL. It's generally
ignored, because it is generally the result of an error in the SELECT.
Essentially, you want to print each record say 3 times. That is, you
want the cartesian product of the number of records and 3. Here's the
original code:
select * from records into cursor stuff
report form whatever
Here's the new code:
create cursor junk (dummyfield c(1))
append blank
append blank
append blank
select * from records, junk into cursor stuff
report form whatever
This will take each record in {records}, multiplied by the number of
records in {junk} and print out that many labels.
> I've designed custom price tags for a small clothing manufacturer in Report
> Designer. What I need is a way to print, let's say any given item, more
> than once (in fact, user defined amount of times). Each item is
> represented in an inventory table as separate record. Each style, size,
> color have an unique code assigned to it (primary key).
> How can I print X number of same information stored in a record in a Report
> w/o creating a, let's say cursor that holds x number of same record as
> records? Any ideas???