ssrs 2008 CAML

My data source for the SSRS Report 2008 R2  is Sharepoint list 2010.
I have parameters by name Section and Project Lead and are cascading. How to implement multi select for Section parameter and Project Lead parameter. How do I write CAML query to implement the same. Any help will be appreciated.screenshot1.png
asrithapAsked:
Who is Participating?
 
nishant joshiTechnology Development ConsultantCommented:
You need to apply changes to below two items:

Report
In report,open parameter for section and choose multi select option.
Query
In CAML query,I don't have that much idea but you can write in clause for selected parameter as you will receive comma separated value.

check below link for in clause.

http://sharepointfordeveloper.blogspot.in/2012/05/sharepoint-2010-using-in-operator-in.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.