Convert Rows To Columns Using Dynamic Pivot In SQL Server

In this article, we will show How to convert rows to columns using Dynamic Pivot in SQL Server.

PIVOT rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output, and performs aggregations where they are required on any remaining column values that are wanted in the final output.

Note: The demo in this article based on database from the TechNet Gallery.


We have decided to build a dynamic database by creating only three tables as shown below:

 Continue reading “Convert Rows To Columns Using Dynamic Pivot In SQL Server”


This page can’t be found when Edit List In SharePoint Designer


I have tried to click on edit list in SharePoint Designer option from the list ribbon,

Edit List In SharePoint Designer from browser

but unfortunately, I got the below error.

This page can’t be found

No webpage was found for the web address:

I have SharePoint Server 2013, and the SharePoint Designer 2013 is already installed.

Also, in Central Administration, the SharePoint Designer has been allowed to be used in this Web Application as shown below.

This page can’t be found
Cause Continue reading “This page can’t be found when Edit List In SharePoint Designer”

Missing Security Settings in Project Online

In this article, We will discuss and solve the issue of

Missing Security Setting in PWA Settings in Project Online.


In Project Online > PWA Settings, you can’t find the Security Settings as shown below.
Missing Security Settings in Project Online


Continue reading “Missing Security Settings in Project Online”

Show / Hide fields based on a dropdown selection using SPUtility.js

In this article, I’ll explain How to show and hide fields based on a Choice field selection in ‘New Form’, ‘Edit Form’ and ‘Display Form’ in SharePoint 2013 / 2016 via SPUtility.js?


  • Download SPUtility.js.
  • Upload the downloaded file (SPUtility.js) to an appropriate place in SharePoint Site like ‘Style Library’.
  • Create a Custom list.
    • Add a choice field displayed as ‘Drop-Down Menu‘.
    • Fill your choices as you need.
    • Add the fields that you need to show or hide based on the selected value of choice field.


Continue reading “Show / Hide fields based on a dropdown selection using SPUtility.js”

Missing Data Connection Library In SharePoint

In this hint,  I will elaborate How to show the missing Data Connection Library In SharePoint?

If you are working on InfoPath or Excel Services in SharePoint, you will need to use a Data Connection Library to save your external connection files like a “udcx” file.
But sometimes, when you tried to add a new Data Connection Library you may miss it in Add an App Page.

missing-data-connection-libraryCause: Continue reading “Missing Data Connection Library In SharePoint”

Hide List View Header Menu via CSS in SharePoint

In this hint, I’ll show How to hide SharePoint ListView column header menu via CSS for print : Continue reading “Hide List View Header Menu via CSS in SharePoint”

Conditional Formating in SharePoint Display Form via JQuery

In this hint, I’ll show How to apply a Conditional Formating in the Display Form based on a specific field value via jquery?


I have a SharePoint list field called ‘Status’, I need to apply a conditional formatting on its row based on its value in the ‘Display Form‘ as the below condition.

  • If (Status == “In progress”) then set the background color row to green.
  • Else set background color row to red.change-background-row-color-in-sharepoint-display-form

Steps: Continue reading “Conditional Formating in SharePoint Display Form via JQuery”