When you pass parameters to a report you pass simply a value or list of values - there is no condition attached to the data It is up to the SQL behind the report to interpret the values Using Dynamic SQL (not good practice but will do for the sake of explanation) you could have 3 parameters: 1: Field_Name (Param1) 2: Condition (Param2) 3: Value (Param3) Pass through to your stored proc and build the SQL like strSQL = "SELECT Foo FROM Bar WHERE " + Param1 + Param2 + Param3 exec(strSQL) Other alternative is to customer program in ASP.NET where you provide your own "parameter" area, take inputs and pass to the report as you wish (parameter area can be hidden in either reportviewer control or via html url configurationRgds Geoff

ok using SSRS 2008 r2 When viewing reports in Sharepoint when you click on it , opens up and has parameters on right hand side. What i need is to have Parameter Name, Condition (and,or,<,>...) , Value How do i add the condition the the report via report builder? or is this something that needs custom programming ?