Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 13, 2012 06:56 PM by Gindy39
Feb 07, 2012 08:18 PM|LINK
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!!
Feb 13, 2012 06:56 PM|LINK
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.