Date:         Thu, 17 Dec 2009 09:59:24 -0500
Reply-To:     Ya Huang <ya.huang@AMYLIN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ya Huang <ya.huang@AMYLIN.COM>
Subject:      Re: Dynamic Report
Comments: To: shiva.saidala@GMAIL.COM

This kind of interaction can be done two ways, first is on the server side,
which means when user click the header, it triggers a recalculation of the
report on the server, the newly generated report is then put back to the
web server, user can see the updated (sorted) new report.

Another ways is to do the clinet side sorting, which requires client side
scripting, such as Javascript. Do a google search, you can find some
sample.

Either way, this is not easy.

On Thu, 17 Dec 2009 05:08:44 -0800, shiva <shiva.saidala@GMAIL.COM> wrote:

>Hi,
>
>Can we create a dynamic sort after report is generated.
>
>For e.g.:
>I have developed one report in html format.If the user wants to sort
>by any field in the report itself can we do that using proc report or
>any other solution.
>This is the final report we got from sas.
>Name Id  sal
>Ram 5 100
>Ravi 3 300
>
>Now can we sort this report once it is generated by clicking on name
>or id or sal (like if we click on the column name it should get sorted
>by that column).
>Or can we give an hyper link to this report.
>
>Thanks,
>Shiva