Place Unsorted row at end of detail

Hi There

I have a row returned from my stored procedure called 'Total', I would like it to appear at the bottom of the detail section rows.

I have placed the below expression on the sort on the table, trouble is now that 'Total' is not being sorted it appears at the top. Is there a way to get it to the bottom?

=iif(Fields!Item.Value <> "Total", true ,false)

Thanks in advance

Dave

several possible options

reverse the true and false part of your expression|||

Thanks for the reply,

-I cant reverse the true and false, as i need the rest of the rows sorted alphabetically

-need it sorted ascending

-Use an inetger, not sure whta you mean here?

Thanks

Dave

|||

Then put 2 things in your sort of the table:

firstly sort by: =iif(Fields!Item.Value <> "Total", 1 ,2)
then sort by: =Fields!Item.Value

So all your detail rows will get a 1 in the first sort expression and be sorted by name in the second expression and your total filed will get a 2 in the first expression and hence come after your detail rows.

|||

Legend,

Thanks fella that worked a treat!