Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Sorting a table across multiple columns

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 17
Accepted Solution

Sorting a table across multiple columns

Hi,

 

In the report designer is it possible to implement an "order by" clause across several columns? So for example:

 

Order by site, subject, visit, page

 

Or does this "order by" have to be implemented in a data prep query? Also, will this "order by" clause be correctly output when used in report designer ?

 

I want to fix the order in the report design and not have the user change it if possible. (Using v7.3.)

Thanks.

Mike

 

 


Accepted Solutions
Solution
‎05-12-2018 04:41 AM
Super User
Posts: 4,011

Re: Sorting a table across multiple columns

In VA 7.4 the List Table object has an Enable Sorting check box. If you sort your columns in the order you want using Cntrl mouse click on the column headers to select more than one column at a time I think you will be able to get the sort order you want - you then save the report. By leaving the Enable Sorting check box un-ticked then you can't change the sort order in the Report Viewer.

View solution in original post


All Replies
Super User
Posts: 4,011

Re: Sorting a table across multiple columns

If you want that sort order across all VA reports, then it is better to do it in the preparation stage.

 

What report objects do you want to fix sort order in? Please note summary-style reports will usually sort in alphanumeric order by default.

Occasional Contributor
Posts: 17

Re: Sorting a table across multiple columns

Currently table objects.

 

So just to clarify you cant perform a hard coded multi column "order by" directly in the report designer? 

Solution
‎05-12-2018 04:41 AM
Super User
Posts: 4,011

Re: Sorting a table across multiple columns

In VA 7.4 the List Table object has an Enable Sorting check box. If you sort your columns in the order you want using Cntrl mouse click on the column headers to select more than one column at a time I think you will be able to get the sort order you want - you then save the report. By leaving the Enable Sorting check box un-ticked then you can't change the sort order in the Report Viewer.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 226 views
  • 0 likes
  • 2 in conversation