Sorting a table with a parameter

1 Answer 31 Views
Interactivity Report Parameters Sorting
Marvin
Top achievements
Rank 2
Veteran
Iron
Marvin asked on 27 Apr 2022, 04:24 PM

I am trying to sort a table Asc/Desc based on a parameter so that the user can sort as they wish.

I know the sorting option is available with interactivity, but that doesn't work in my scenario because I need to save the setting outside of the report. The software we're developing can save the parameter as the user chooses, which is why I need a parameter rather than interactivity.

I haven't found a way to do do this, and wondering how to accomplish this.

1 Answer, 1 is accepted

Sort by
0
Accepted
Marvin
Top achievements
Rank 2
Veteran
Iron
answered on 27 Apr 2022, 07:33 PM

I found a work-around from someone who was showing how to do dynamic sorting in another program. 

I created 2 Calculated Field based on the parameter, and added both of them to the sorting option. One is sorted ASC and the other DESC

= Parameters.YearMonthListOrder.Value = "A" ? Fields.FiscalYear : ""

= Parameters.YearMonthListOrder.Value = "D" ? Fields.FiscalYear : ""

 

Tags
Interactivity Report Parameters Sorting
Asked by
Marvin
Top achievements
Rank 2
Veteran
Iron
Answers by
Marvin
Top achievements
Rank 2
Veteran
Iron
Share this question
or