Assign title automatically for Document Library

Introduction

As we all know about Document Libraries in SharePoint. We have a drag and drop option in SharePoint 2013 libraries. The thing is, SharePoint doesn't give an option to enter title while uploading. We need to go Edit Property screen to enter title. So, here i am going to provide a SP workflow to assign title automatically while uploading. 

SP Workflow

Here is the steps to assign the title.

• Open your site in SharePoint Designer
• Add a new list workflow, choose your document library in the drop down list 
• Then, Workflow editor will open with Step1

• Click Condition at ribbon
• Choose If any values equal value

• Then, Change value with Current Item: Title is Empty
• Click Action to set value

• Set Title to Current Item:Name

• Result will be

Unexpected error on server associating the workflow

Some of us might be faced this issue while publishing the workflow from SharePoint designer. To resolve this, need to extend the UserDefinedWorkflowMaximumComplexity limit for the web application.

Run the following script in your farm

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") 

$new_limit = 10000;

$web = Get-SPWebApplication "your web application URL"

$web.UserDefinedWorkflowMaximumComplexity = $new_limit 


$web.Update()

SharePoint list report creation using SSRS

Introduction

I am going to share an idea about creating SSRS report with SharePoint List. First create a base list in SharePoint site. Here is the steps to create a report

SSRS 

Open your report builder. We will get start up dialog box which is having an options like New Report, New Dataset, Open and Recent. 

Then, Click Chart Wizard under New Report. First we need to create dataset which is going to provide data to chart. Choose Create a dataset and click Next

Choose the connection data source. We have to connect source of data. Here we are going to connect SharePoint list as source. 

Click New. Then we may get Data Source Properties window. Give name for the Data Source. Choose SharePoint List in Connection Type. Give SharePoint site URL in Connection strin box. Click Test Connection for the confirmation of connection.Then, Click Ok

Published Data Source will be displayed once connection established. 

If we want edit the connection we have an option in this window. Click Next if there is no change in data source.

Next, We will get Design a query window. Here we can choose the list from data source. we have an option to filter at right side.

I have chose Discussion List to get chart. Then Click Next. 

Next window is used to choose the chart type. Chart types are Column, Line, Pie, Bar and Area. I have chose Column chart type.

Click Next

Arrange chart fields window is displaying now. Here we need to choose the field for create chart

We will land to Chart style window once we clicked Next. Here we can choose defined style for chart

Click Finish.

Now we were landed to Chart Editor screen. Here we can able to edit Chart Properties.

Click Run at top ribbon. Chart will display in Run window.

server could not complete your request sharepoint designer

Most of us came across this issue while open the site using SharePoint Designer. 

Do following steps to resolve this,

• Goto IIS
• Check SharePoint Web Services site's authentication
• Enable Anonymous Authentication