Unanswered: Return one row for each date in a date range
I am using Crystal Reports 2008 querying a single table. Each record contains a StartDate and an EndDate. My task is this:
For each selected record, I need to generate additional, separate rows for each calendar day in the date range (including the endpoint). Each row must contain the calendar date and two other fields from that record. E.g., if StartDate is Feb 28, 2012 and EndDate is March 3, 2012, five new rows should be generated (recognizing that Feb 29 is a leap year).
I have tried several different loop control structures, but I always wind up with only one row with the word "True" in a field where I expect a date. Please help!!