• @OperParam works as a drop-down menu containing =, <>, >, <, >=, <= to work with @Date_String. In my parameters folder, available parameters for @OperParam are set as Label: 'Equal To', Value: ' AL1.start_date =', Label: 'Not Equal To', Value: ' AL1.start_date =', and so on. Also in my parameters folder, @Date_String (hidden on report) available/default values are set to expression ="'" + Parameters!Date.Value + "'". Another parameter was created in the folder called @Date (visible to report user).

    I tried using PRINT (@c) in the SSRS Query Designer but when I use the current query, nothing is output. When switch to the hard-coded multi-values then I get an error message saying that the operation cannot be completed.

    "Nicholas"