topic How to get a sorted table by columns in a crosstabulation table in WRS in SAS Web Report Studio

How to get a sorted table by columns in a crosstabulation table in WRS

psysas — Mon, 20 Jun 2011 11:46:34 GMT

hi
Right now my WRS report is sorted by observations(rows) in alphabetical order when the report is opened. Is that possible to get a sorted crosstabulation table by a certain column right away when you click "View Report" ?

thanks in advance

-psysas

Message was edited by: psysas Message was edited by: psysas

Re: How to get a sorted table by columns in a crosstabulation table in WRS

yonib — Mon, 20 Jun 2011 13:17:10 GMT

Hi, you can use proc format that places the selected column values in a specified numeric order.

You can find an example in the following sas note:

http://support.sas.com/kb/33/017.html

I hope this helps you...

Re: How to get a sorted table by columns in a crosstabulation table in WRS

psysas — Thu, 23 Jun 2011 09:38:34 GMT

hi yonib
thanks for your reply.
but the column value is already numeric, i need it sorted when the report is opened.
any ideas?

-psysas

How to get a sorted table by columns in a crosstabulation table in WRS

psysas — Fri, 24 Jun 2011 08:36:43 GMT

anyone has an idea? is that due to the data source which is an olap cube?

How to get a sorted table by columns in a crosstabulation table in WRS

TSBruce — Wed, 29 Jun 2011 16:08:02 GMT

If the source is an OLAP cube, the default view should be sorted based on the sort you defined for that dimension in your cube. You ahve the ability to define the sort order using five options:

1. Formatted Ascending

2. Formatted Descending

3. Unformatted Ascending

4. Unformatted Descending

5. Data set order

I would suggest setting the sort order for this dimension according to how you would like your default view in WRS to appear.

How to get a sorted table by columns in a crosstabulation table in WRS

psysas — Thu, 30 Jun 2011 09:41:11 GMT

hi TSBruce

Thanks for your reply.

it is my fault that I havn´t make it clear. It is the measures that need to be sorted in either ascending or descending order.

really hope someone can help.

-psysas

How to get a sorted table by columns in a crosstabulation table in WRS

BrunoMueller — Thu, 30 Jun 2011 13:13:07 GMT

In the View Mode, you go to the column in questions, use the right mouse button select either sort asceding or sort descending. Then save the report. That should do it.

How to get a sorted table by columns in a crosstabulation table in WRS

psysas — Fri, 01 Jul 2011 07:24:11 GMT

well Bruno, the users require that the column is displayed sorted when they click "View report" in WRS. Is that possible?

How to get a sorted table by columns in a crosstabulation table in WRS

BrunoMueller — Mon, 04 Jul 2011 06:45:30 GMT

When you save the report it remembers the sorting. So when you view a report it will use the sorting you specified

How to get a sorted table by columns in a crosstabulation table in WRS

psysas — Mon, 04 Jul 2011 13:35:52 GMT

ya... but if you have a prompted filter, it will only save the sorting to the report you specified in your filter. An example: your prompted filter has two groups A and B. If you choose group A in your prompt and save the sorting. The report is viewed sorted for group A. But if you opdate your report by selecting group B in your prompt, the report for group B is not sorted.

any idea?

How to get a sorted table by columns in a crosstabulation table in WRS

BrunoMueller — Mon, 04 Jul 2011 14:47:56 GMT

pysas I think you best discuss this with technical support and outline the steps you used to produce the the prompt as well as the report

How to get a sorted table by columns in a crosstabulation table in WRS

psysas — Thu, 07 Jul 2011 10:06:27 GMT

thanks Bruno, i will do that

How to get a sorted table by columns in a crosstabulation table in WRS

TSBruce — Thu, 07 Jul 2011 17:46:32 GMT

I just tested this with WRS4.3 and the sort is remembered and honored even when selecting different values for prompts or anytime the report is opened. It is a requirement to save the report with the sort applied, as this saves the sort in the report definition.