Build Tasks Delegation in SharePoint 2010

Here I am going to explain how you can create a Task Delegation solution. This is required more in companies where the mangers leave for vacations or somewhere.

Create an InfoPath from which contains the following fields:

  • From: Date
  • To: Date
  • Delegate To : UserOrGroup

Now, publish the form to list or document library so the managers then can submit their delegations.

Note: When publish the form, export the fields as library columns as below:

Go to SharePoint Designer and create a list workflow and bind the workflow with Tasks List as you see below.

Enter the workflow name and description.

Create three workflow variables:

  • From: Date/Time
  • To: Date/Time
  • DelegateTo: String

You can assigne the variables by reading their values from the document libray which has to be filled by the above InfoPath form.

After the above step, when click Ok you will get the below warning, click Yes

Now, check the option “Start workflow automatically when an item is created” as below and publish the it.

Note: Don’t check the option “Start workflow automatically when an item is changed”

Enter Log History action to log what happen to the Task item.

Update the Task list with the delegated user as belwo in the screen.

Again log to history after update the task list item.

Now, repeat the same step to get the FROM and To field from the document library.

Now before we update you have to check whether the task was created between the FROM and To date which are specified by the manger.

See below scree;

Let’s try now

Belal fill the delegation form:

Task created for user Belal:

Refresh the tasks list again:


Filter CQWP using Query String

Some time we need to filter the Content Query Web Part based on user selection from dropdown list.

To achieve this, we need to create a page and add the CQWP in that page.

Now configure this web part:

  • Query
  • Presentation
  • In the filter section, do the following

Now, the URL should be:

Publish Posts using MS Word

Here I will explain how to publish your posts to using Microsoft Office Word.

Open the Word and click on Save in the Ribbon.

Click on Register Now

Choose WordPress and click Next

Enter your blog URL, username and password and click OK

You will receive a success message

Now after you finish your registration, you need to write your blog and publish it

Could not find stored procedure ‘sp_dboption’ – Installing SharePoint 2010 on SQL Server 2012

I installed SQL Server 2012 on my VM and I installed SharePoint 2010 , In SharePoint Products Configuration Wizard I got the following Message:

Could not find stored procedure ‘sp_dboption’




  1. SharePoint 2010 Foundation SP1
  2. SharePoint Server 2010 SP1


Speaking in RSUG – May 2012

I just finished my session in RSUG (Riyadh SharePoint User Group). It was at Thuresday 31/5/2012. I talked about Reporting Services in SharePoint 2010.

PresentationRSUG May 2012 Reporting Services in SharePoint 2012