Monday, April 25, 2016

Disable Strict Name Checking in IIS

This is use full in many scenarios. For me it’s more use full for disable keep on prompting credentials in SharePoint 2013 Environment.

In this method you need to add your domain as an exception list to IIS for not checking the FQDN for loopback.

Open the RegEdit.

image

And navigate to

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa

and click on MSV1_0

image

Then add new Multi Connection String

And add BackConnectionHostNames

image

Then you will see that is added to the registry.

image

You can double click and add your fully qualified domain names (One per line) that will be working as an exception.

image

Then you can save and restart the IIS.

Monday, April 4, 2016

Working with SharePoint Report Server using URL parameters in SSRS 2008/2012 in SharePoint Mode – Part One

There is a slightly different between earlier SSRS report parameters and NEW SSRS running in SharePoint server 2013.

URL parameters are slightly different from native mode and SharePoint Mode. This article is only about SharePoint mode parameters.

SSRS running on SharePoint has few parameter types and types are passing to SSRS engine using prefix.

 

Parameter Type

Prefix

Note

Report Viewer Control

rc:

Report Server HTML controller

Report Server

rs:

Report Server to process

Report Viewer Web Part

rv:

Web part parameters

Report Parameters

rp:

Report parameters

Most of the time passing parameters to report is more frequently used than any other Passing the Reports as a URL Parameter

Assume that we have created a Report with parameter interval and need to pass the values from the URL.

image

Let’s see the attributes of the @interval parameter.

image

I have mentioned the visibility as visible but you can also have it as Internal as well. Internal will not be visible to users for selection.

If you are running the report from SharePoint it will having url something like below.

http://www.myportal.com/_layouts/15/ReportServer/RSViewerPage.aspx? &rv:RelativeReportUrl=/ReporlLocation/myreport.rdl&rc:Parameters=Collapsed

Assume that you need to pass the parameter “interval” in url. Thus you need to append the following URL parameter.

rp:interval=cm

URL parameter has three sections

Prefix - rp:

Parameter name - interval

Value – cm

So your final URL will be something like follows

http://www.myportal.com/_layouts/15/ReportServer/RSViewerPage.aspx? &rv:RelativeReportUrl=/ReporlLocation/myreport.rdl&rc:Parameters=Collapsed& rp:interval=cm