Hi,I have a matrix settled upon an MDX Query using Reporting Services 2000.In columns i have the Months and in the Lines and i have Products, so what i need todo is hide the rows that have a 0 value in all months.How can this be achieved?Best Regards,Luis Simes

Hi Luis I am sure you have resolved this but just for the benefit of anyone still looking at this issue that might sumble upon this thread. The easiest way to do this is to use the following expression in the visibility tab of the detail row: =IIF(SUM(IIF(Fields!NameOfYourValueField.Value > 0, 1 , 0)) > 0, False, True) This will first calculate a value for a product accross all the months which is then aggregated by the SUM. Once we have that value we know that if all months were 0 then the aggregated value should also be 0 and thus we want to hide that row. If the value is greater than 0 then we know that we have values in at least one of the months and thus we show the row. Kind Regards,