Create a Data Form Web Part using SharePoint Designer

To insert a Data Form Web Part, follow these steps:
  1. Open a new Web Part page in SharePoint Designer 2010.
    You can either create your Web Part page in the browser and open it in SharePoint Designer, or you can use SharePoint Designer to create the new Web Part page for you.
  2. Click the Design tab to view your Web Part page in Design mode.
  3. On the Insert tab, click the Data View button and choose Empty Data View.
    SharePoint Designer inserts a new Web Part on the page, and a new set of tabs appears in the Ribbon
 


After you insert the Web Part, your next steps are to select the data source, add your columns, and apply sorting, filtering, and conditional formatting as desired.
To select your data source:
  1. Inside the Web Part, click the Click Here to Select a Data Source link.
    The data sources picker appears.
  2. Select the list or library you want to display in your Web Part and click OK.
    The Data Source Details pane appears.
  3. Ctrl-click the columns you want to appear in your Web Part.
  4. Click the Insert Selected Fields As drop-down list and then choose an option to display the content.
    You have several options:
    • Single Item View or Multiple Item View: Inserts the selected fields so that the Web Part displays one item at a time or several rows at once, respectively.
    • Single Item Form or Multiple Item Form: Displays a data entry form using the field(s) you select.
    • New Item Form: Displays a form for entering new items into your data source 
 


 

Now the Data Form Web Part appears on the screen.
Add / Remove the Columns by using the tab in the Ribbon


Now if you want sort / group based on the coumns required 


Now if you want to filter the Data Form web part by using the Query string. Use Conditional Formatting and do the steps. 

 

Comments

Post a Comment

Popular posts from this blog

Activating a SharePoint Feature on Multiple Sites or Site Collections using PowerShell

I need to either activate or even deactivate certain features on multiple site collections. So the below script will allow you to do this.. First step create a text file in the below format, you only need to define the URL for each Site collection or site. SiteURL http://sharepointsuresh/sites/site1 http://sharepointsuresh/sites/site2 http://sharepointsuresh/sites/site3 http://sharepointsuresh/sites/site4 http://sharepointsuresh/sites/site5 http://sharepointsuresh/sites/site6 You can list all features installed on your sites by using the following PowerShell: Get-SPFeature | Sort -Property Scope,DisplayName | FT -GroupBy Scope DisplayName,Id Then use the below PowerShell Script: $SiteList = Import-Csv Sites.txt ForEach ($item in $SiteList) {             If ($item -ne $null)             {                 Write-Host "Activated Branding Feature for: $($item.SiteURL)" -...
Read more

Managed Path with WildCard and Explicit Inclusion

I thought to put an article on Managed Paths in SharePoint covering their use with Explicit Inclusion and Wildcard Inclusion and also how to use them in Real World scenarios So let’s see what Managed Path is Managed Path: By default when we create Site Collections inside a Web Application in SharePoint they are created with the URL “http://servername:portnumber/site”.  But if we want to have a specific URL other than “/site” we need to create Managed Path. So as an example if we want to create Site Collections for IT and HR Dept and want to have URL's like “http://servername:portnumber/IT” and “http://servername:portnumber/HR” we can do with the help of Managed Paths. Managed Path helps to have site collection with the URL other than “/site”. Managed Path can be created in Central Administration in Application Management under SharePoint Web Application Management. When we create Managed Path either we can select Explicit Inclusion or Wildcard Inclusion. So let’s see what ...
Read more

List All SharePoint 2010 PowerShell Commands

Use this PowerShell command to output a list of all cmdlets that are found within the SharePoint 2010 namespace: Get-Command –PSSnapin “Microsoft.SharePoint.PowerShell” | format-table name > C:\SP2010_PowerShell_Commands.txt If you would like a little more detail, then try this one: Get-Command –PSSnapin “Microsoft.SharePoint.PowerShell” | select name, definition | format-list > C:\SP2010_PowerShell_Commands.txt
Read more