Search code examples
t-sqlreporting-servicesssrs-2008

Incorrect syntax when attempting to use two values in order to create a parameter in SSRS


I'm attempting to create a parameter for when jodrtg.fdescnum <> inmastx.fbin1. I want to be able to use this in a dropdown list selection for my report. I have tried a number of combinations but keep getting syntax errors near the <or =.I'd be appreciative if anyone can point me in the right direction. I've never tried using two fields to create a single parameter before.
This what I've been attempting to get as my final result.

jodrtg.fdescnum <> inmastx.fbin1 = @MoldPress


Solution

  • I learned that you can only use one operator at a time but they can be combined using bool logic.
    WHERE (jodrtg.fdescnum <> inmastx.fbin1 OR @ParameterName = 'Unfiltered')