-
Show Fake Data
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.
-
Re: Show Fake Data
A small (SQL, vb or whatever language it's used to select data) script would do it
-
Re: Show Fake Data
Yes. Which RDBMS are you using?