SQL Server Performance

Using Filters AND/OR ???

Discussion in 'SQL Server Reporting Services' started by steveness, Sep 26, 2004.

  1. steveness New Member

    Probably a simple question...
    Does anybody know how to change a filter in Reporting Services to OR rather the AND. I have tried without success, the field is grayed out and always defaults to AND yet the help clearly states AND/OR.
    Any help would be appreciated.
  2. Logicalman New Member

    In the DataSet designer, did you place the Param names in consecutive columns or type the statement sirectly in using OR?
  3. steveness New Member

    Hi,
    Works fine in the dataset query, what I was trying to achieve was in the report layout filtering the data returned for a table using OR without affectin ghte dataset returned.
    I guess really I should just do it at the dataset stage and have multiple datasets.
    Cheers.

Share This Page