Show Fake Data

[jigi23]

Please look at the following.

Table Name : tmpTable

There are two fields in this table 1) tmpName and 2) tmpDate.

There are 4 rows in this table:

row# tmpName tmpDate
1 ABC 08/01/08

2 PQR 08/05/08

3 STU 08/09/08

4 XYZ 08/13/08

Now, I want to show following display on Crystal Reports:

Date Name
08/01/08 ABC
08/02/08 ABC
08/03/08 ABC
08/04/08 ABC
08/05/08 ABC PQR
08/06/08 ABC PQR
08/07/08 ABC PQR
08/08/08 ABC PQR
08/09/08 ABC PQR STU
08/10/08 ABC PQR STU
08/11/08 ABC PQR STU
08/12/08 ABC PQR STU
08/13/08 ABC PQR STU XYZ

So, I'm trying to add the fake data on the reports.

Please help me.
Thanks in advance.

[jggtz]

A small (SQL, vb or whatever language it's used to select data) script would do it

[Madhi]

Yes. Which RDBMS are you using?