SSRS – SharePoint Lists Default VIEW

March 22, 2018

Once you connect to a SharePoint List you will always get connected to the list using the DEFAULT VIEW.

Which might not be what you want because it can be a FILTERED View. And therefore not showing you all the records you want.

SOLUTION :

1. Go to DataSet –> Query

image

2. Apply a Filter

image

Strangely enough if you DO NOT Apply a filter in the Query Designer. It will fetch the data using the DEFAULT VIEW set in SharePoint ???

So basically in order to get ALL the DATA, you need to SET a FILTER that covers the whole range in your data set.

Very contradictory approach Confused smile

Enjoy !

Advertisements

SSRS – SharePoint Lists HTML Tags

March 22, 2018

If you are working a lot using SSRS against SharePoint Lists.

You will see that some lists that contain Text are not displayed properly… Sad smile

See Example :

image

The first column shows the raw output with all the HTML Tags.

While the second column shows you the proper output you need for the report.

SOLUTION :

1. You first need to add a PLACEHOLDER in the column

image

2. Secondly put in the field that has the HTML text, and choose HTML as MARKUP TYPE

image

Enjoy !