Posted 25 October 2021, 5:49 pm EST
I have an object { level1: “sort1”, level2: “sort2” }
with sort1, sort2 being the mutable input
I used “Table grouping” in ActiveReportsJs tool to sort the data group.
I see that the expressions section in the ActiveReportsJs tool only supports static variables.
For example: { Sort1 }
I tried to make it a dynamic struct by passing values corresponding to each sort level
For example
expression group one:
{Switch(
level1 = “Sort1”, “{Sort1}”,
level1 = “Sort2”, “{Sort2}”
)}
expression group two:
{Switch(
level2 = “Sort1”, “{Sort1}”,
level2 = “Sort2”, “{Sort2}”
)}
It didn’t work as expected. Looks like it was not supported.
Could you please take a look and let me know if you have any suggestion?
Thanks.