Hi,
I'm creating a calendar style crystal report (CR 2011) and it works great if the values I'm bringing from the subreport to the main report are single date values.
However, I'm attempting to report on equipment that is dispatched over a date range. For example, Equipment # "X22" is dispatched from a start date of November 1, 2012 through to an end date of November 4, 2012. I would like my calendar report to indicate "X22" on each of the dates November 1, 2012, November 2, 2012, November 3, 2012, and November 4, 2012 inclusive. That way when you look at the calendar for the month of November one can see that Equipment # "X22" is dispatched on those 4 days.
As it stands, I'm linking from the main report with the formula "weeknumber" (DatePart("ww",{calendar_date1.caldate}))...to the subreport (there are 7 subreports - one for each day of the week) which as the formula...
"weeknumber" (DatePart("ww",{job_has_dispatch1.start_date})).
So, I'm only linking on the dispatch start date which I recognize is a problem. How do I identify the date range?
Appreciate the help!
Mark