Home > SSRS > SSRS – SharePoint Views

SSRS – SharePoint Views

SharePoint views are one of the main topics while integrating SSRS with SharePoint. It can be used to setup reports Cache, Snapshot, Processing time-out and many more options. Here planning to discuss SSRS Cache plans setup using SharePoint views.

Step 1: Log on to the SharePoint portal with Admin permissions and select the Manage Content and Structure from Site Actions

Step 2: Select the SSRS reports site and Edit Properties i.e. BI Demo Site is the project folder used for this demo

Step 3: We transferred to Library settings and select the Create view option as

Step 4: Select the required views and here using Standard view format as

Step 5: Name the view name and required setting and most of the time we go with default options and this screen will transfer to SSRS reports library

Step 6: Select Manage Processing Options to the required reports. Here we can setup the views to all reports or only to the required report, here considering to setup to only the required report as

Step 7: We have many of processing options settings, select Use cached data and configure option for custom settings as

Cusotom setting configurations will give options as

We can see the final settings information on the report as

Points to consider:

1. Discussed only a basic setup of Cache plan but same view can also be used to setup snapshot of the report
2. Cache and Snapshot settings depends on the default settings of report parameters so watch out for SSRS parameter settings
3. Cache settings depends on the Data Source permissions settings i.e. Stored Credentials and Windows Credentials

Advertisements
Categories: SSRS Tags:
  1. No comments yet.
  1. No trackbacks yet.

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: