Group visability expression

• mnq

  SSC Enthusiast

  Points: 131

  More actions

  August 11, 2012 at 12:47 am

  #392934

  I've got a list of items grouped by category. The items are sorted by sort order...and if the first item row (sort order 0) has the same heading as it's category name then I want the category header row to be invisible. But if the first row is not equal to category name then I want to display the category name in the header row.

  This case I want the group header row, A, to be INVISIBLE:

  Value - ParentGroup

  A (grouped by parent group)

  -- A - A

  -- B - A

  -- c - A

  This case I want the group header row, Z, to be VISIBLE:

  Z

  -- W - Z

  -- X - Z

  -- Y - Z

  I was thinking something like this in the Hidden expression for the group header...but the problem is that I only want it to be evaluated against the first row of the group, is this possible?

  =iif(Fields!Value.Value = Fields!ParentGroup.Value, true, false)

• H4K

  Hall of Fame

  Points: 3374

  More actions

  August 24, 2012 at 1:07 am

  #1529579

  I think the only way you can achieve this by using Rank & Partition in a SQL query.

  And then using it in the hidden expression.

  For Ex. if(new_field = 1 and your _expression, true, false)

  There maybe other ways to solve this. but i'm not sure about them.

  BI Developer
  SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
  Please visit... ApplyBI