Interactive Sorting When Table Has Groups

To sort correctly on a table that has multiple groups, the correct scope needs to be specified. The default selection for the scope is 'Detail Scope'. Often times, this needs to be changed to a different grouping.

Jump to URL Opens a New Window

Use Java script to open a new window on a link of a report. If the dynamic value is part of the URL, be aware of the data type. Use CStr() function if the dynamnic value is not String data type.

This method only works when the report is displayed within a browser (I only tested IE7).

Here is an example:

"javascript:void(window.open('http://StaticProtionOfTheURL" & CStr(DynamicValue) & "','_blank', 'location=no,toolbar=no,left=100,top=100,height=600,width=800'))"

Use JOIN() Function to Display All Members of A Multivalue Parameter

Sometimes you want the report to display all the pamameters that are applied, especially when the parameter section is hided. To do that, you can simply use a text box and and point the value to the parameters. However, to display all members of a multiple value parameter, you will need to use the JOIN() function.

For example, if you have a parameter called Area that filters work items by the Area field, the following expression will allow you to display all the selected areas on the report.
="Area: " + JOIN(Parameters!Area.Label, ", ")

Thanks to a post I found on bokebb.com. Here is the link to it:
http://www.bokebb.com/dev/english/2008/posts/2008112686.shtml