arross21
November 17th, 2008, 04:27 PM
I'm working on a report that is pulling calendar events based on input of a user and date range.
This part is real simple and the code is below. The problem is that an event can repeat for several days. For example an event can have a event date (database field is cal.ondate) of Nov17 but in the same row from the database it has column called duration and duration is 2. This means that this event occurs twice for Nov17 and Nov18. All this info is in one row. So when I run the report it onlys pulls one event for the Nov17. I have tried several different ways but I'm unable to get the event to repeat for Nov18. Thanks,
Stringvar sUser:= uppercase({?USER});
if {CAL.USERID} = sUser then
{CAL.ONDATE} in {?BEGINDATE} to {?ENDDATE}
This part is real simple and the code is below. The problem is that an event can repeat for several days. For example an event can have a event date (database field is cal.ondate) of Nov17 but in the same row from the database it has column called duration and duration is 2. This means that this event occurs twice for Nov17 and Nov18. All this info is in one row. So when I run the report it onlys pulls one event for the Nov17. I have tried several different ways but I'm unable to get the event to repeat for Nov18. Thanks,
Stringvar sUser:= uppercase({?USER});
if {CAL.USERID} = sUser then
{CAL.ONDATE} in {?BEGINDATE} to {?ENDDATE}