Grouping by date

brijleo

Hi All,

I have a scanerio in which i have to develop a report in which i have group by date, but the field in which date is stored is datetime data type.
is their any way so that data in the report can be grouped by only date not datetime.

Thanks!

garak

for grouping in reports you need a key where the field to group is in the key (at position one or two in the key).
If you doens't have a key you can only group with using a temporary table and using the integer dataitem (bevore you must convert your dateTime to date).