I have a calendar report that seems to work fairly well. The main report is the calendar itself, with the dates/days, etc.
To show the courses on each day I have inserted a subreport. It works fine, except that courses are inserted based on their start date, and sometimes we have two or three day seminars instead of one-day seminars. In the table, all courses have a start date. Only those that last more than one day have an end date. I would like to somehow run code telling the report that if there is an end date to show the course on every day from the start date to the end date.
I assume this would need to be on the "OnOpen" even of the Report, but I don't know code enough to generate it myself, so I'm hoping someone has some ideas!
To show the courses on each day I have inserted a subreport. It works fine, except that courses are inserted based on their start date, and sometimes we have two or three day seminars instead of one-day seminars. In the table, all courses have a start date. Only those that last more than one day have an end date. I would like to somehow run code telling the report that if there is an end date to show the course on every day from the start date to the end date.
I assume this would need to be on the "OnOpen" even of the Report, but I don't know code enough to generate it myself, so I'm hoping someone has some ideas!