Grouping on a Multivalued Field

[dmattarn]

I have a report that is grouped by a few criteria, one of which is a multivalued field "manager". The report displays "purchase orders" grouped by "customer" and then again by "manager". some of the "purchase orders" have 2 "managers" and currently the grouping separates the 2 managers into 2 sections and shows the same purchase order below both.

Is there a way to make the group heading show both managers together with the purchase order beneath it just once?

thanks in advance for any help

 

[Ranman256]

youd need a query to group the managers,
select managers, group from table

JOin this manager grouping query to your data,
then your report would use the ManGroup as the sort, instead of Manager Name.

 

[dmattarn]

what do you mean group the managers in a query?

 

[arnelgp]

try looking for ConcatRelate function in this forum, or google it.

 

[arnelgp]

sample you can study.