Interactive sort, forcing a row to remain at the end still cant get it to work

Hi,

Im trying to do an interactive sort , one of the rows returned from my datasource called 'Total' i wish to display at the bottom always. is there a way i can do this?

I've tried the below on the column header but the total is either at the bottom or the top how can i check the ordering if Ascending or Descending? Then i cld swop the 1 and the 2 around.

=iif(Fields!Item.Value <> "Total", 1 ,2) & Fields!Item.Value

Otherwise doesnt anyone know how to palce a row from the detail section into the footer?

Many thanks

Dave

This approach should work fine. Maybe the item value contains blanks. You may want to try to just add another detail textbox that shows the result of =(Trim(Fields!Item.Value) <> "Total").

Once you get the expected results, modify the sort expression for the interactive sort accordingly.

-- Robert

|||

Hi All

I'm Climbing the walls here, does anyone know how to do an interactive sort but keep one of the returned rows pinned at the end of the result set?

I've tried =(Trim(Fields!Item.Value) <> "Total") & Fields!Item.Value but the Total ends ups either at the top or bottom of the result set.

E.g

Results

d

e

a

b

c

Sort would return

a

b

d

e

c

with c remaining at the bottom

i get the above when ascending sort which is fine but descending i get

c

a

b

d

e

Thanks in advance

Dave

|||Anyone?

Interactive sort, forcing a row to remain at the end

Hi,

Im trying to do an interactive sort , one of the rows returned from my datasource called 'Total' i wish to display at the bottom always. is there a way i can do this?

I've tried the below on the column header but the total is either at the bottom or the top how can i check the ordering if Ascending or Descending? Then i cld swop the 1 and the 2 around.

=iif(Fields!Item.Value <> "Total", 1 ,2) & Fields!Item.Value

Otherwise doesnt anyone know how to palce a row from the detail section into the footer?

Many thanks

Dave

This approach should work fine. Maybe the item value contains blanks. You may want to try to just add another detail textbox that shows the result of =(Trim(Fields!Item.Value) <> "Total").

Once you get the expected results, modify the sort expression for the interactive sort accordingly.

-- Robert

|||

Hi All

I'm Climbing the walls here, does anyone know how to do an interactive sort but keep one of the returned rows pinned at the end of the result set?

I've tried =(Trim(Fields!Item.Value) <> "Total") & Fields!Item.Value but the Total ends ups either at the top or bottom of the result set.

E.g

Results

d

e

a

b

c

Sort would return

a

b

d

e

c

with c remaining at the bottom

i get the above when ascending sort which is fine but descending i get

c

a

b

d

e

Thanks in advance

Dave

|||Anyone?

Interactive sort, forcing a row to remain at the end

Hi,

Im trying to do an interactive sort , one of the rows returned from my datasource called 'Total' i wish to display at the bottom always. is there a way i can do this?

I've tried the below on the column header but the total is either at the bottom or the top how can i check the ordering if Ascending or Descending? Then i cld swop the 1 and the 2 around.

=iif(Fields!Item.Value <> "Total", 1 ,2) & Fields!Item.Value

Otherwise doesnt anyone know how to palce a row from the detail section into the footer?

Many thanks

Dave

This approach should work fine. Maybe the item value contains blanks. You may want to try to just add another detail textbox that shows the result of =(Trim(Fields!Item.Value) <> "Total").

Once you get the expected results, modify the sort expression for the interactive sort accordingly.

-- Robert

|||

Hi All

I'm Climbing the walls here, does anyone know how to do an interactive sort but keep one of the returned rows pinned at the end of the result set?

I've tried =(Trim(Fields!Item.Value) <> "Total") & Fields!Item.Value but the Total ends ups either at the top or bottom of the result set.

E.g

Results

d

e

a

b

c

Sort would return

a

b

d

e

c

with c remaining at the bottom

i get the above when ascending sort which is fine but descending i get

c

a

b

d

e

Thanks in advance

Dave

|||Anyone?

Interactive sort

Hi,

Im trying to do an interactive sort , one of the rows returned from my datasource called 'Total' i wish to display at the bottom always. is there a way i can do this?

I've tried the below on the column header but the total is either at the bottom or the top how can i check the ordering if Ascending or Descending? Then i cld swop the 1 and the 2 around.

=iif(Fields!Item.Value <> "Total", 1 ,2) & Fields!Item.Value

Many thanks

Dave

*Bump*, anyone?

Interactive Debugging of Stored Procedure

In VS 2005 with SQL Server Express: How do I debug a stored procedure that is called from a object datasource control while the asp.net code is running?

Thanks

You may need to PRINT debugging information in the stored procedure, or use SQL Profiler to capture a trace when executing the stored procedure.