Monday, March 12, 2012

Interactive column sort

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 this

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

Doesn't work to well

Results to Sort

d

e

a

b

c

Sort should return

which works fine on the ascending sort

a

b

d

e

c

with c remaining at the bottom

But i get this on the descending sort

c

a

b

d

e

Thanks in advance

Dave

Dont use sort expression, just use the direction...

then exclude 'c' from detail records (display if item <> 'c') and include 'c' in the footer (if item='c')

Shyam

No comments:

Post a Comment