gczychi Posted Wednesday at 11:01 AM Posted Wednesday at 11:01 AM (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 Wednesday at 11:05 AM by gczychi
comment Posted Wednesday at 11:15 AM Posted Wednesday at 11:15 AM 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.
gczychi Posted Wednesday at 12:18 PM Author Posted Wednesday at 12:18 PM Wow, thanks for the quick answer! Works like a charm!
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now