Grouping [Resolved]

[vbXML]

Hi All,

When I do grouping in reports, I usually use two fields, GroupId field and a GroupDesc field. I group by the GroupId field and use GroupDesc for the group header on the report.
what I feel: From the application-design point of view I feel I must send as less data as I can, so I was thinking if I should send only the GroupDesc field and use it for grouping as well as the header!
But I also have a strong feeling that grouping on the text field may be not efficient.
How do you experts compare this? Thanks much in advance for you views/suggestions/adivse!

[ducky]

I would not get worried about passing a description when creating a query for the report you describe. Ultimately I would group on what the intended user prefers ID or Description. No matter the sort I always show both the ID and description in the group header. Just remember if you change to group on description it may not be the same sort order as when you group on the ID.

[vbXML]

Thank you, ducky!