Hi,
is there a way to get a text list of all subsummary values of the current list layout?

My layout looks like this (simplified):

Account1    12.33
Account1    25.44
Total Account1    47.77

Account2    36.11
Account2    52.09
Total Account2    88.20
...

Is there an easy way to get a text list of all the subsummary fields that looks like this:

Account1    47.77
Account2    88.20
...

At the moment, I am using an ExecuteSQL query, but it gets too complex for that small task (the FoundSet is more complicated).

Thanks a lot for any help!

Edited March 26, 2025Mar 26 by gczychi

8 minutes ago, gczychi said:

Is there an easy way to get a text list ...

Not exactly easy, but not too difficult either: look at the 'Fast Summaries' technique by Mikhail Edoshin.

You could also export the records grouped by the Account field. Depending on why you need this, this could be the easiest method.

 

Wow, thanks for the quick answer!  Works like a charm!