topic Sorting and Ranking in Web Report Studio in SAS Web Report Studio

Sorting and Ranking in Web Report Studio

DavidPhillips2 — Tue, 10 Jul 2018 14:32:05 GMT

In Web Report Studio, 4.4 M3, I’m trying to display the top 20 objects in descending order. When I sort descending before ranking the sort works. When I rank the sort takes no effect.

Re: Sorting and Ranking in Web Report Studio

Madelyn_SAS — Tue, 10 Jul 2018 15:23:47 GMT

Can you post a screen shot that illustrates the issue? I see no issues sorting on a column that has been ranked.

Re: Sorting and Ranking in Web Report Studio

DavidPhillips2 — Tue, 10 Jul 2018 16:49:15 GMT

added screenshot

Re: Sorting and Ranking in Web Report Studio

Madelyn_SAS — Tue, 10 Jul 2018 17:39:27 GMT

Please try this:

Right-click the label "Transfer Institution."
On the menu, select Remove All Sorting.
Right-click the label "Transfer Institution" again.
On the menu, select Sort Ascending (or Descending) by First Year Transfer.

Re: Sorting and Ranking in Web Report Studio

DavidPhillips2 — Tue, 10 Jul 2018 18:27:29 GMT

Thanks, it looks like it was double sorted.

Re: Sorting and Ranking in Web Report Studio

Madelyn_SAS — Tue, 10 Jul 2018 18:44:47 GMT

I think that the rank automatically applies a sort, so that any subsequent sorts are secondary sorts. Glad that removing all sorting worked!