Create SSRS Report from SharePoint 2013 List using Report Builder 3.0

Reporting Service integrated with SharePoint provides a rich reporting platform. Lets see how we can create SQL Server reporting services report from SharePoint list data: Create a Library for Reports and add Report Content Type To start with, Lets create a Document Library,  Add Report Builder Report content type to create a…

Read more

How to Create and Deploy SSRS 2012 Reports to SharePoint 2013?

Reporting Services integrated with SharePoint 2013 gives you Rich enterprise reporting features. We’ve our SQL Server 2012 Reporting services integrated with SharePoint 2013 already. So now we can create reports for SharePoint 2013 using both SQL Server Report Builder 3.0 and using Visual Studio. Lets create a SQL Server Reporting Services Report…

Read more

Configure SQL Server Reporting Services (SSRS) 2012 Integration with SharePoint 2013 – Step by Step Guide

This implementation guide walks through step by step on configuring SQL Server Reporting Services 2012 Integration with SharePoint 2013. What’s New in SSRS 2012 with SharePoint 2013? Unlike its previous versions, SSRS 2012 with SharePoint 2013 installation & configuration has been greatly simplified.  There are lots of changes in installing & Configuring…

Read more

Get All SharePoint Server Details (Server Name, IP, Role, Status, etc) in the Farm using PowerShell

Requirement: Quickly retrieve and document details all server in the SharePoint Server farm. Solution: Get all servers in SharePoint farm To get all Servers in SharePoint farm, We use: Get-SPServer cmdlet. Lets include Server Name, Role and Status fields from SharePoint farm servers The above cmdlet retrieves all servers in the SharePoint…

Read more

Site Use Confirmation and Deletion in SharePoint 2013

Site use confirmation and deletion feature in SharePoint helps to keep your content up to date by removing unused site collection automatically. To manage this feature, head on to:  SharePoint 2013 Central Administration site Application Management >> Click on the “Confirm Site use and deletion” link. In the Site use confirmation and…

Read more

How to Create State Service Application in SharePoint 2013?

When tried using browser-based forms, InfoPath farm services gave me this error message: “The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server State Service. For more information, contact your server administrator.” How to Create State Service Application in SharePoint 2013? State service stores temporary…

Read more

Create SharePoint 2013 Search Service Application using PowerShell

Although we can create SharePoint 2013 search service application from Central Administration,  I prefer creating it through PowerShell as it gives the ability to get rid of GUIDs in Search service Database names. Also, from SharePoint 2013 Central Administration, Its not possible to modify search topology! So, PowerShell is the ideal way…

Read more

Bing Maps with GeoLocation Column in SharePoint 2013

SharePoint 2013 introduced a new functionality called “Geolocation” as a Field type to enable location based data in SharePoint lists. So with GeoLocation field, we can bring “Map” experience to the users.  Geolocation Field type is not enabled by default. We have to do few configurations to make it available in SharePoint…

Read more

Integrating Windows Live ID, Google and Facebook Authentications with SharePoint 2013

The federated authentication mechanism handles authentication by external providers which send the token back to SharePoint. So, Instead of creating accounts internally (in AD, SQL Server) for external users and partners, We can make use of external authentication providers like Microsoft Live ID Accounts, Google, Yahoo, Facebook accounts (or even external Active…

Read more