Filter for a group in Matrix

• Kawior

  Valued Member

  Points: 74

  More actions

  June 2, 2012 at 4:31 am

  #261953

  I have matrix which is grouped in last instance by the first two leters of the text

  E/

  EK

  U/

  U1

  UA

  US

  UZ

  One table shows only values filter like E* - that works nicely.

  On the second table I like to see values filter on (left(Field,2)="U/" or Left(Field,2)="U1")

  I tried this in group properties in expression = True but it is not working.

  Can anyone help me build code for this or how to successfully filter this?

• Steph Locke

  SSCrazy

  Points: 2963

  More actions

  June 7, 2012 at 7:33 am

  #1498159

  Have you enforced the bracketing that the example uses i.e. brackets around each condition, to see if it's a problem with your conditions or syntax?

  The example provided on the expression editor is:

  =(Fields!YearlyIncome.Value > 50000) Or (Fields!NumberCarsOwned.Value > 1)