Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Tips and Tricks
Message Icon Topic: Group by range of dates Post Reply Post New Topic
Author Message
WWUDAVE
Newbie
Newbie
Avatar

Joined: 22 Dec 2011
Location: United States
Online Status: Offline
Posts: 1
Quote WWUDAVE Replybullet Topic: Group by range of dates
    Posted: 22 Dec 2011 at 5:51am
I am new to Crystal Reports 2008 and have not been able to find a solution to this:
 
I have a table of events. Each record has a start date and an end date. Many events occur over a range of dates.
 
I want to print a calendar of events, in date order. (every event that occurs on each date)
 
Since the only dates stored in the table are the start and end dates, I need a way to print each event on the report for each day that it occurs. To print based on the date range, rather than the start or end date. i.e. if the event starts on 12/22/2011 and ends on 12/24/2011, I need it tp appear on the calendar on 12/22, 12/23 and 12/24.
 
??
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 28 Dec 2011 at 12:05pm
You'll need to have some sort of calendar table that has all of the dates in it.  You would then join from the event table to the calendar table on the calendar date field between the event start date and the event end date.  Use the calendar date on the report instead of the event dates and you should get one record for each day where an event took place.
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.