Hello

 

Is it possible to capture the fields sorted by in a variable?

 

I have a sub-summary report with multiple sub-summary parts.

The script will be set to Sort Records with dialog so users can take out or rearrange the order of the fields.

I'd like to capture the actual sort order and use the variable as a header in the report.

I see sort state as a get function, but don't see a get function for sorted fields. Is it possible to capture?

Thank you.

I have heard of doing this by saving a snapshot link and then parsing the XML, but I haven't done it myself.

Interesting solution. I'll have to give it a try for future use.

 

For the specific report I created, for how users have started using the report, capturing the sort fields seems less important than it did when  I created it. They're usually only picking one field and it's obvious which one it is.

 

Thanks