"WHERE clause" in text box to filter results

• lk-681111

  SSCrazy

  Points: 2915

  More actions

  July 7, 2009 at 12:04 pm

  #211891

  Hello:

  Is there an equivalent of a "WHERE" clause that I can put in a text box to filter its results? I have a text box and a matrix (which is grouped by person) that I placed in a list, and I want the text box to display a sales count for each person. For very convoluted reasons, these tables can't be joined, so I have the person data and the sales data in two separate datasets. I need the text box to basically be the equivalent of:

  =Sum(Fields!SalesCount.Value, "Sales") WHERE (Fields!PersonID.Value, "Sales") = (Fields!PersonID.Value, "matrix1")

  Does this make any sense?

• dmounday

  SSC Eights!

  Points: 920

  More actions

  July 8, 2009 at 9:13 am

  #1021770

  Have you tried setting a filter on the table/matrix control?

• Dave Klug

  SSCertifiable

  Points: 5811

  More actions

  July 9, 2009 at 5:43 am

  #1022279

  =SUM(iif((Fields!PersonID.Value, "Sales") = (Fields!PersonID.Value, "matrix1"), (Fields!SalesCount.Value, "Sales"), 0))