Trying to display imaginary records

[Mike_Cutts]

Hello____I have a scenario which requires me to display records in a report which don^t exist in a database. The scenario I have is as follows:____A table in a database which stores records for times of meetings. I have a start time of the day and an end time for the day. What I would like to do is display the records in the database, together with the ^imaginary^ records in between. For example, if my day starts at 09:00 and ends at 11:00 (if only!) and has the potential for a meeting every 15 minutes, and I have a meeting between 10:00 and 10:15, I would like the report to display as follows:____09:00 - Nothing__09:15 - Nothing__09:30 - Nothing__09:45 - Nothing__10:00 - Meeting__10:15 - Nothing__10:30 - Nothing__10:45 - Nothing____Please bear in mind that the table in the db will only have 1 record for the whole day.____Probably a very poor explanation of the problem, but if you can understand it and provide any feedback, it would be much appreciated.____Thanks,____Mike.

[Nick]

an interesting problem -____i would suggest using a product like MS Visual Basic or Visual Foxpro to generate a DBF with ALL the needed records. The program would generate a record for each 15 minute time increment and fill in data that is REAL where it finds data for that record in the DBF that contains the REAL entries. ____Then use RR to report from that generated DBF.____The program should be able to generate any selected time periods so that the DBF could be re-generated as needed. I would suggest over-writing the same DBF each time you run the program.____nick__

[kfleming]

And you could even use R&R to generate this one record for each time database. Just take any database with enough records, and then create a calculated field that increments the required time.__Export to DBF and you are all set.____Kathleen__R&R Support

[Mike_Cutts]

Thanks for the replies, will try them.