Forms Designer Forum

Posted: **04 Sep 2017**

The image below should be pretty self explanatory, grouping by category and you can see the category column there. This is in an forms designer related items view.

Posted: **04 Sep 2017**

Hello, Karl!
Group by and Totals work fine in our tests. Here is an example of Related Items:

: GroupRelatedItems.png (7.5 KiB) Viewed 1383 times

I'm not sure what causes weird behavior on your site, but can you provide us more information?

We'll need to know what version of SharePoint you are using and version of your Forms Designer. You can tell us about Category field - is it a Choice or a Lookup? We'll also need to know configuration of Related Items:

: RelatedItemsConfig.png (5.12 KiB) Viewed 1383 times

: DataSource.png (4.95 KiB) Viewed 1383 times

Additionally, you can let us know if there is anything special about grouping you are doing. I've tried to replicate your setup, but if I got something wrong with Group by or Totals - let me know!

As an experiment, you can try switching Related Items Render mode to Server and see if it works or not:

: RelatedItemsConfigServerRender.png (5.39 KiB) Viewed 1383 times

Forms Designer Forum

Grouping not working properly

Grouping not working properly

Re: Grouping not working properly