Group by in Report

nhel

Hi Nav Developers!

How can i make my set of record distinct?
Or in sql statement "select fieldname from tablename group by fieldname"

Thanks in advance.

Karenh

If there is not a key on the field you want to group by, create one.

Then create the report. Use the report wizard, and choose to group on your field.

Edit the report and delete the body section. The group header will output a distinct value.

nhel

Hi Karenh,

Is there any other way of making this grouping,if my report is now existing?

Any idea how can be done by coding?

Thanks in advance

Karenh

yes

In the properties for the table in the report. dataitemview, select the key that is on the field you want to group on.

Still in properties, Group By, enter the field you want to group on.

Then edit Sections and insert section GroupHeader for the table. Place your textboxes on this section.

bob's your uncle

nhel

Hi Karenh,

thank you very much,it really works to my report.

Thanks a lot!!

You rock!!