Hi all, I created a matrix and it has a column on the far right with no data in. Is there a way to delete this column, of hide it.

Hi TYHGWAS, Based on my experience, your matrix are created in SSRS 2005 environment, right? If so, as a workaround to hide the total column as following. Suppose part of matrix is like following, with a row group named matrix1_Year which group on =Fields!Year.value, and a column group named matrix1_Catagory which group on =Fields! Catagory.value: The yellow area is in matrix1_Year scope, but the gray area is not in this scope. 1. Right-click the textbox containing “=Sum(Fields!Amount.value)”, choose properties. 2. In Visibility tab, select Expression, click the expression button below. Then set the expression as:”=Iif(InScope(“matrix1_Year”) and InScope("matrix1_Catagory"),false,true) 3. Delete SubTotal in the textbox. Note:Limitation here is, though the content in the total column has been hidden, they leave the column as blank by design in SSRS 2005. Since later version from SSRS 2005 (like SSRS 2008/SSRS 2008 R2), the interactivity has been greatly improved. You can delete or hide a column much more easily and flexible: How to: Insert or Delete a Column (Reporting Services) To hide static columns in a table, matrix, or list Thanks, Lola Please remember to mark the replies as answers if they help.