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

Hi, 1) Add a calculated field to the dataset. (double click the dataset, go to fields tab, add a caculated field, set the field name for example as 'MyRowOrder', set the value expression as =iif(Fields!MyColumn.Value="Manual Counts",1,0). Note : Please replace the MyColumn with the column that has the Manual Count value. 2) Click on the tablix that uses the dataset, on the groups pane (located bottom left), right click the group concerned and select properties. on the sort tab, click add and select the calculated field created in above step MyRowOrder. 3) Run the report and observe the result. Please feel free to discuss if you have any further questions. Regards Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH