How to write where clauses in SSRS Reporting services? RRS feed

  • Question

  • User533496661 posted


    I want to write some where clauses in SSRS reporting services.

    How can i write the following query equivalent of SSRS query string:

      Select * from some_table where s.SUPP_NAME like '" & Replace(request("suppliername"), "'", "''") & "%' "    AND (f.CAUSE_CODE_1 in (" & request("causecode") & ") OR  f.CAUSE_CODE_2 in (" & request("causecode") & ") OR f.CAUSE_CODE_3 in (" & request("causecode") & "))"  

    If someone can give me some example of how to do handle this kind of conditions ,it would be great!!



    Tuesday, February 7, 2012 4:18 PM


  • User-1756429883 posted

    What do you want the result to be though?

    Because you can place all that  in a dataset, and it will yield everything from the result,  and on a table you call all the fields .  But in an Expression for a table or a matrix, I doubt you can be that specific.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, February 13, 2012 2:56 PM