Jump to content

Recommended Posts

Posted (edited)

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 by gczychi
Posted
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.

 

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.