"Justin30519" wrote:

> Hello. I am using DevStudio 2003 to develop a report in Reporting Services
> 2000. I am having a hard time getting sorting to work. When I move my mouse
> over a column name, it becomes a hand to indicate that it is a link. When I
> click on it, there are two problems:
>
> 1. It opens a new report in a new window. (I want it to keep the same window.)
> 2. The sorting doesn't work at all. It loads the same exact report again.
>
> Here's what I did:
>
> 1. I defined SortOrder as a report parameter. (String, allow blank value.) I
> did not pass this into my stored procedure because I thought Reporting
> Services knew how to handle SortOrder on its own.
> 2. For each column in my table, I went to Properties, Advances, Navigation
> and put the following in Jump to URL:
>
> = Globals!ReportServerUrl & "?" & Globals!ReportFolder & "/" &
> Globals!ReportName &
> "&ReportProcParam1=" & Parameters!ReportProcParam1.Value &
> "&ReportProcParam2=" & Parameters!ReportProcParam2.Value &
> "&SortOrder=ReportParam3" &
> "&rc:Toolbar=false"
>
> (I have replaced the parameter names for clarity.)
>
> Can anyone offer any insight? Thanks in advance.
>