SSRS - How to move a row to last row in a tablix

[nandan619]

Hi,

How can i set a specific row to be always displayed as the last row in a tablix,in SSRS 2008.

I have grouped some columns and in them, i always want to display a column which has "Manual Counts" name as the last row in that group.

Can anyone please help me on this?



Thanks

Nandan

 

[xlbo]

Best bet is to probably add a column to your SQL

case when name = 'Manual Counts then 99 else 1 end as OrderBy

Then add a sort to your group to sort by 'OrderBy'

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question