Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    12

    Question Unanswered: Filtering rows in reporting services

    Hi,

    I have a report using a matrix, but i need to filter the rows with a total column equal to cero, but i can't find the way to define a filter in this case.

    I don't want to do a calculation in the query to filter the values. If you know how to do that, please tell me.

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    Nottinghamshire, UK
    Posts
    364
    You could set the row to invisible if = SUM(Columns) = 0 using the calculation in an expression
    "Everything should be made as simple as possible, but not simpler." - Albert Einstein
    "Everything should be made as complex as possible, so I look Cleverer." - Application Developer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •