Grouping on datetime fields restricts records
Posted on 2006-03-31
Using Crystal reports 8.5 with sql database odbc.
Have a report which must be grouped by an appointments datetime field. When they entered the data they mistakenly entered two appts. at the same date and time. Once generated they can not go back and change the entry. The report is only showing one of the appts. not both. Have group set to group on datetime field by seconds but they are exactly the same. Both are 3/27/2006 10:30:00 am. If I group by patients ID number all correct records show but when grouping on datetime I loose one record. Have tried several things, no answer. Can someone help?