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!!
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 karthik_newbie on Feb 14, 2012 01:10 PM
karthik_newb...
Member
93 Points
70 Posts
How to write where clauses in SSRS Reporting services?
Feb 07, 2012 08:18 PM|LINK
Hi,
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!!
Thanks!!
Gindy39
Member
246 Points
99 Posts
Re: How to write where clauses in SSRS Reporting services?
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.