Grouping by date

brijleo
brijleo Member Posts: 70
edited 2009-02-06 in NAV/Navision Classic Client
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!

Comments

  • garak
    garak Member Posts: 3,263
    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).
    Do you make it right, it works too!

Categories