https://communities.sas.com/t5/SAS-Enterprise-Guide/Web-Report-Studio-question/m-p/73189#M7278 I know this is the EG forum but as there isn't a forum available for the BI Tools hopefully this will suffice.<BR /> <BR /> In the edit mode of WRS I have a cross tab and one of the columns is for a date. I'm trying to get this sorted descending so the latest period is at the left, but i can't find an option to do this.<BR /> <BR /> This can be done from the view report screen by left clicking on the field to be sorted but I'd rather make all the changes in edit mode especially when I have up to 6 tabs to change within each report<BR /> <BR /> Derek Sun, 08 Feb 2009 22:02:36 GMT DerekAdams 2009-02-08T22:02:36Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Web-Report-Studio-question/m-p/73189#M7278 I know this is the EG forum but as there isn't a forum available for the BI Tools hopefully this will suffice.<BR /> <BR /> In the edit mode of WRS I have a cross tab and one of the columns is for a date. I'm trying to get this sorted descending so the latest period is at the left, but i can't find an option to do this.<BR /> <BR /> This can be done from the view report screen by left clicking on the field to be sorted but I'd rather make all the changes in edit mode especially when I have up to 6 tabs to change within each report<BR /> <BR /> Derek Sun, 08 Feb 2009 22:02:36 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Web-Report-Studio-question/m-p/73189#M7278 DerekAdams 2009-02-08T22:02:36Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Web-Report-Studio-question/m-p/73190#M7279 As per my Knowledge there is no such type of option in WRS.<BR /> the source data in IMS it self u have to modify the table as u want the display in WRS. u can sort the variable in IMS.<BR /> <BR /> venkatesh. Wed, 11 Feb 2009 07:04:52 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Web-Report-Studio-question/m-p/73190#M7279 venkatesh 2009-02-11T07:04:52Z