Post Author: rwolters
CA Forum: Crystal Reports
I'm using Crystal XI release 2 and I'm having a problem grouping data by date. Here's an example of what's happening. There are a number of records in my table in a sql server database with an effective date of 10/1/2007. When I group by this date, the value being displayed in the group heading is 9/30/2007 and the value being displayed in the detail records is 10/01/2007 12:00:00AM. Does anyone have suggestions on how to get both dates to display the same? Both dates need to be represented as 10/01/2007. I'm not interested in displaying the time.