Hi All,
I have this question below.
I have a main report which will pull out an event.
In the Event table, it have a StartDate and EndDate.
I have create a sub report to show a concurrent event.
I passed Startdate and EndDate to the sub report as parameter.
Will like to know how can I write the code in the subreport of Select Expert to only select concurrent Event which Start and End date follow with the Main Event Start Date and End date.
Example:
Main Event --> Start Date: 29 July 2016, End Date: 2 Aug 2016
Event A --> Start Date: 30 July 2016, End Date: 30 July 2016
Event B --> Start Date: 2 Aug 2016, End Date: 3 Aug 2016
Event C --> Start Date: 28 July 2016, End Date: 3 Aug 2016
Event D --> Start Date: 28 July 2016, End Date: 30 July 2016
Event E --> Start Date: 28 Aug 2016, End Date: 28 July 2016
In the Concurrent Subreport, Event A, Event B, Event C and Event D will show.
Event E will not show.
This is what i wrote but not complete.
({EV200_EVENT_MASTER.EV200_EVT_START_DATE} in {?Pm-EV200_EVENT_MASTER.EV200_EVT_START_DATE} to {?Pm-EV200_EVENT_MASTER.EV200_EVT_END_DATE} OR
{EV200_EVENT_MASTER.EV200_EVT_END_DATE} in {?Pm-EV200_EVENT_MASTER.EV200_EVT_START_DATE} to {?Pm-EV200_EVENT_MASTER.EV200_EVT_END_DATE}) and
Can advise how can i complete this code?
Thanks.
Regards,
Mavis