SSRS – SharePoint CAML Queries – How to ?

Building CAML queries in SharePoint is not so easy, especially making complex queries using parameters etc.

Well there are tools available in the internet that can help. But maybe you have a tool at hand you didn’t think of immediately ?

Report Builder can do the job :

Open a new report and link to the SharePoint List you want to attack.

Open the Query Designer

image

Select the fields you need and click on the FILTER icon. Add your Filter Field and check the PARAMETER box.

image

Run the Query to test it, and if OK click EDIT as TEXT

image

And voila your CAML Query is properly formatted !

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: