Re: ODS HTML question

[Sowmol]

Hi,

Does anyone here know how to create the column names /labels in an ODS HTML report so that they are clickable and then if they are clicked, the report will be sorted by that variable?

Thanks.

 

[ChrisW75]

Hmmmm. I've never seen that done. It would require the use of ActiveX components or Java or something like that.
An alternative method would be to create multiple reports all sorted by different variables, and have the column headings as links to those alternative reports.
To set up a link you'd want to turn of the "protectspecialchars" option (I think it's ODS Protectspecialchars=OFF;") and include the link in the label for the column...

 

[Sowmol]

Hi Chris,

Thanks a lot for your reply.. Will try out your suggestion of multiple reports..

Thanks again.

 

[ChrisW75]

Also you want to check out the SAS Support site, they have alot of code samples, do a search and you should find them pretty easily.

 

[macroCharlie]

Check out this SUGI tutorial:

http://www2.sas.com/proceedings/sugi24/Internet/p189-24.pdf