Printing A Calendar Of all days even those without an appointment

[posero]

I would like crystal 6/7 or 8 to print a report of all the appointments someone has one month at a time.&nbsp;&nbsp;The report should print all dates, even returning blanks if the selected person has no appointment on that day.<br><br>Thanks !

 

[MalcolmW]

As this type of reporting can be common, a good way of dealing with it is to create a calendar in the database, consisting of just one primary indexed field (a date).&nbsp;&nbsp;Populate this with a few years of dates, and outer join to it whenever you want all the dates in a date range. <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>