Hello,
Is there any way we can sort the HTML output of the report in Report Studio after the report is run? I know we can do it during the report creation process, however, what if the user runs the report & then afterwards wants to sort it by some other column.
Thanks for your input.
There is definitely a way, but it's not visually pretty. I remember doing this in the report studio advanced class. I'll dig it up if no one else answers in a few days.
You can achieve this by using Java script.
Rgd's
Venu
There are old instructions I wrote at http://it.toolbox.com/wiki/index.php/Dynamically_sort_columns%2c_no_code_required%2c_c8 (I don't think the code works anymore but the instructions should still work). The main thing to remember is that it WILL re-run the query.
I found the instructions, It's what angela posted. you create an auto-submit value prompt on your report. you can place it next to the column if you like. The value prompt contains static choices that point to a sort key for the column, I'm sure you can figure it out from there.
Unfortunately, this looks VERY ugly and is not a simple click and sort. However, i can see why that functionality doesn't exist as a link because Cognos uses links as drill-downs.
IBM/Cognos has a method on their website for sorting any column. Its for version 8.2 and its pretty neat looking using some java script they wrote. Heres the site: http://www.ibm.com/developerworks/data/library/cognos/page201.html
Hope this helps.