topic Re: Sort on Hidden Column in SAS Web Report Studio

Sort on Hidden Column

RSB — Thu, 25 Nov 2010 13:38:39 GMT

Is there a way we can sort a listing in WRS on a Hidden Column(Which has the Desired order)?? I have to retain a specific order of values in the report (not in alphabetical order) and I cannot find a way to do that.

Thank You.

Re: Sort on Hidden Column

twocanbazza — Thu, 25 Nov 2010 18:37:32 GMT

Have you tried not sorting the vars in the information map/WRS and use the dataset order.... if only a listing...

Barry

Re: Sort on Hidden Column

RSB — Mon, 29 Nov 2010 11:18:01 GMT

I have unchecked the Sort property option on the Data Item from the Information map, ordered my data in the original data as per my requirement.

However when displayed in the WRS the items are listed alphabetically, I guess that is a default behavior of the WRS.

Re: Sort on Hidden Column

twocanbazza — Mon, 29 Nov 2010 18:36:09 GMT

RSB

What version are you using?

Also Is it a straight table listing or does the table/report perform some summarisation?

Barry

Re: Sort on Hidden Column

RSB — Tue, 30 Nov 2010 11:15:31 GMT

Hi Barry,

Version of WRS : 4.2 M2

It is a straight listing without any summarization.

Re: Sort on Hidden Column

AngelaHall — Tue, 04 Jan 2011 20:55:33 GMT

Just ran across this Knowledge Base entry:
http://support.sas.com/kb/33/017.html

Could be helpful for custom sorting.

~ Angela
http://sas-bi.blogspot.com