duplicate record base on a quantity field

[Pablito9]

Hi All

I’m trying to duplicate a record based on a quantity field of a Progress database table using Crystal Reports 8.5.
The connection to the database is through a ODBC MERANT 3.60 32-BIT Progress SQL92 v9.1D driver (pgpro915.dll).

I only use one table; within this table there is a quantity field. With a parameter is select only one record from the table. Now I would like to duplicate this record x times as the value in the quantity field.


Many Thanks in advance

Erik

 

[Madawc]

I'm not clear what you want. Is it to repeat the same data on the basis of a field in the record. E.g. [Oranges 2], [Apples 3], [Pears 1] should appear.

Oranges
Oranges
Apples
Apples
Apples
Pears

You could do that with multiple detail sections: right-click and [Insert Section Below]. Suppress the second detail if the quantity is less than 2. The third if it is less than 3. And so on.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Please see faq149-3226.

-LB

 

[Pablito9]

I’ll try to be more precisely.
The record I’m retrieving from the database is unique, so when using the parameter field only one record will be displayed.
So when searching for a “Orange” only one record containing “Orange” will be displayed.
This record contains a quantity field that has a value 3

So what I would like to see the following;

Orange
Orange
Orange


If the quantity field that has a value 2 then the result will be;

Orange
Orange

I hope its clear now

 

[IdoMillet]

As LB suggested, see my FAQ on this: FAQ149-3226

- Ido


Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Pablito9]

Ok, but is it possible to do so using only one table?

 

[IdoMillet]

What is the maximum value in Quantity?

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Pablito9]

maximum quantity value is 500

 

[IdoMillet]

In that case, you need to go back to Plan A. Create the Repeater table...

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com