Hide data based off a row header value in a Matrix

• Somebody

  SSC Eights!

  Points: 928

  More actions

  November 30, 2006 at 5:07 pm

  #171113

  Hi everyone,

  I am brand new to Reporting Services and currently developing a simple report by using matrix.  I have row with country value and the row is month value.  The problem is that I don't want to show some countries but I need countries to be included in the dataset for other matrixes. 

  Would anybody please help me on how to not to SHOW these specified countries?

  Thanks!

• Kurt Kracaw

  Ten Centuries

  Points: 1116

  More actions

  December 1, 2006 at 9:22 am

  #675177

  Based on your question, Use your Reporting Services Books Online and query

  Drilldown Reports and Hiding Items

  There is a description on how to hide items in a Matrix.

  If I missed the point of the question let me know and I can try again. Hope this helps

  Kurt

  Kurt Kracaw

• Vandy

  SSCommitted

  Points: 1827

  More actions

  December 1, 2006 at 9:53 am

  #675189

  Just select the col. by  clicking and click right mouse button ->Properties->advance->Visibility-> here you can click on hidden radio button.

  Now selected col. will not be visible....

  Do you want to show data related to that country or not because my solution will hide full col.