BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Mikey03
Obsidian | Level 7

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

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

3 REPLIES 3
SASKiwi
PROC Star

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.

Mikey03
Obsidian | Level 7

Currently table objects.

 

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

SASKiwi
PROC Star

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.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

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