Tag: SharePoint 2010

Cascading Drop Down List In SharePoint 2010

SharePoint 2010 has provided lot of things Out-of-box and it’s just a matter of configuration.But some times we don’t know how to achieve that functionality. Today We will discuss Cascading  Drop down List in SharePoint 2010.


As we know InfoPath as a Microsoft Office product features a different usage-scenario from the other Office applications, such as Word and Excel. In order to use InfoPath to fill in a form, a user must have a designer develop an InfoPath template first.

All the data stored in InfoPath forms are stored in an XML format, which is referred to as the “data source”.

InfoPath provides several controls and For each controls, actions (called “rules”) can be bound in. A rule defines a specific action that will be performed under certain conditions.  So we will Achieve our goal using Infopath forms.

So will follows following steps :-

  • Create a Custom list called ‘states’.
  • Add States to the list: Maharashtra, Uttar Pradesh, Rajasthan, Gujrat etc..


  • Create another list for Cities and called ‘cities’.
  • Go to the list settings of ‘cities’ and click on ‘create column’. Create a Lookup column called ‘State’. with following information. Get information from: ‘states’,  in this column: ‘Title’



  • Add some cities to this list. I created multiple cities at each location.



We have need to create one more Custom List where we apply this …

  • create a new Custom list called ‘MyHomeTown’.
  • Click on ‘Create column’ and create a Lookup column called ‘State’. Get information from: ‘states’,  in this column: ‘Title (as earlier screenshot )
  • Repeat above step, for create a Lookup column called ‘City’. Get information from: ‘cities’,  in this column: ‘Title’



  • Open the list settings for ‘MyHomeTown’ and click on ‘Form settings’.
    You will see a label with the text ‘Customize the current form using Microsoft InfoPath’. Click OK.


customize the current form

  • The MyHomeTown form will now be opened in InfoPath 2010.


  • Right click on the State field, and select properties.
    Select ‘Get choices from an external data source’ and click ‘Add…’.
    Create a connection with the following settings:-



1. New connection, receive data


2. Receive data from: SharePoint library or list


3. select ‘states’ library


4. select the ‘id’ and ‘title’ column.


5. Do not check the box for making a copy of the data.


6.check the box that asks for automatically retrieving data when the form is opened. Save the external data source as ‘states1′


  • At value, choose ‘ID’ and at display name, choose ‘Title.
  • Right click on the City field, and select properties.
    Select ‘Get choices from an external data source’ and click ‘Add…’.
    Create a connection with the following settings:

1. New connection, receive data


2. Receive data from: SharePoint library or list


3. select ‘cities’ library


4. select the ‘id’, ‘title’ and ‘State’ column.


5. Do not check the box for making a copy of the data in the form Template.


6. do not check the box that asks for automatically retrieving data when the form is opened. Save the external data source as ‘cities1′


  • At value choose ‘id’, choose ‘Title’ for  the display name.


We have almost Done, just few steps are remaining here. 🙂 🙂

  • Click on the xPath button at the properties dialog of Room next to ‘Entries’.Click on the ‘Filter data’ button.



  • Click on ‘Add’.


1. In the first column, choose ‘select a field or group’.


2. A window pops up .Select the ‘main’ datasource, click on ‘dataFields’ and select ‘State’


3. In the second column, choose ‘equals to’.

4. In the third column, choose ‘select a field or group’. Again a window pops up,


5. Select the ‘rooms’ datasource, click on ‘dataFields’ and select ‘State’.Click OK .



6. The filter will now look like ‘State equals State’. Now close all property dialogs.


  • Select the State column and click on ‘Add Rule’. Select the query action when the field is changed



  • Now choose the data connection ‘cities1′ and click OK.


  • Again, click State and make a new rule: When the field is being changed, set a value for a field.


  • Choose field ‘City’ and leave value empty.


Finally! We are done. Fast publish the form to SharePoint again by pressing ctrl+shift+Q. Now if you carefully executed all steps above, you will see a form like this:



Ting ting Titing  🙂 🙂 🙂



SharePoint 2010 Enterprise Single Server farm Installation


Before starting actual steps, we would like to understand few basic concepts. So What is farm? Farm is group of Co-related, interdependent still isolated Applications.

Farm can be deployed as

  1. Multi-Server Farm: in which different servers have different roles, like someone has web Server Role, Application Server Role and Database server Role.
  2. Single server farm: In this all above Roles are assigned to Single Server. All of Above roles Played by Single Server. In single server farm we can add more servers later.
  3. Stand-Alone farm cannot add another Server in future.

Today we will see how to setup single server farm.

Minimum Hardware Requirements For Single server farm:-

  1. 64 bit processor.
  2. 8 GB for production use in a single server or multiple server farm .For test Installation we can use 4 GB RAM.

Software Requirements For Single server farm:-

  1. Windows Server 2008 or 2008 R2 (64 bit).
  2. The 64-bit edition of Microsoft SQL Server 2008 R2.We can also use SQL Server 2008.
  3. Service packs 2 update. Now we can use Service pack 1 for SQL Server 2008.
  4. Or Microsoft SQL Server Enterprise 2005 64 bit with latest service pack and cumulative updates.
  5. Cumulative update package 2 for SQL Server 2008 Service Pack 1.
  6. Microsoft SharePoint Server 2010 Enterprise Installer.

For more details on pre-requisites and proper planning refer http://technet.microsoft.com/en-us/library/cc262485.aspx

Security Requirements For Single server farm:-

  • Active directory domain controller (AD/DC) must install on server to create and Assign roles to user.
  • Create A three Account in Active Directory users and Computers as given below:-

                      1Installation User:- srv-sp-setup
                      2.  SQL User :- srv-sp-sql
                      3.  Farm Admin :- srv-sp-farm

  • Give the Domain Admins and Local Administrator rights to these three accounts.
  • To install SQL server 2008, login with srv-sp-sql Account.
  • Assign the “Dbcreator”, public and “Securityadmin” roles to “srv-sp-setup” and “srv-sp -sql “in Sql server.
  • To install Microsoft SharePoint 2010, Login with Srv-sp-setup Account.
  • SharePoint 2010 server Configuration wizard should run with srv-sp-farm account.

There are Few Simple Steps Afterword we are able to install single server farm easily. Follow the following steps:

  • Double click on SharepointServer.exe .it extract all files


  • Firstly install all the prerequisites as shown below, for that you require Internet Connection on your server. If you don’t have internet connection on same server .then Download SharePoint 2010 Prerequisites to other machine where Internet connection is available and put that prerequisite on shared location and Access it. Following are prerequisites which should be downloaded offline if direct internet connection is not available.
  1. 1. Application server role. Web server (IIS) Role.
    2. Microsoft SQL server 2008 Native Client.
    3. Hotfix for Microsoft Windows(KB976462)
    4. Windows identity foundation(KB974405)
    5. Microsoft Sync Framework Runtime v1.0(x64)
    6. Microsoft chart control for Microsoft .Net framework 3.5
    7. Microsoft filter pack 2.0
    8. Microsoft SQL server 2008 Analysis services ADOMD.NET
    9. Microsoft server speech platform runtime (x64).
    10.Microsoft server speech recognition language- TELE(en-US)
    11. SQL 2008 R2 Reporting Services SharePoint 2010 Add- ins.
  • Now here we have Internet Connection, Click on prerequisites.


  • After clicking on Prerequisite Welcome screen comes and in below there is a box in which you can see list of prerequisites.


  • Click Next. License Agreement Screen Appears .click on the check box and accept the terms and condition. Then click next.


  • After clicking next prerequisite installation begins. It will take few minutes



  • After Few minutes installation is complete click on finish button.


  • Now we are going to SharePoint Single server installation. Click on Install SharePoint Server.


  • After clicking on Install SharePoint Server Product key window appear, insert your product key. Then continue.


  • Read the Microsoft Software license term, then click continues.


  • After click on continue button next screen comes here you can select Standalone or Server Farm. Now we are looking for Single server farm Installation .So we are Clicking on Server farm Option.


  • After clicking on server farm. Next screen provide option to choose server type, complete or Stand-alone .Now we are clicking on complete and then click on Install Now.


  • Now your Installation is start.




  • Now click on the close button, but before ensure the check button is check .so the configuration wizard runs automatically.


  • After click on the close button SharePoint Configuration Wizard runs automatically .Click on next Button.


  • After clicking on next button one pop Window comes click on yes.


  • After Clicking on yes, Next screen provides the option to choose an existing server farm or create a new server farm. Because we are installing single server farm so there is no existing farm. Let’s choose create a new server farm and click next.


  • Then in the next screen we can set our database with SharePoint 2010 server, here we can give the Database name and domain user name and password. You can change your database name to more secure your database because it is default database name any one can access your database .Now we can go for default database name because it is our demo configuration. Username is our domain Administrator it does not require any specific permission. Through this account we can manage the central Administrator of SharePoint farm. Take a screenshot of this screen for future use. After putting all information click next.


  • After clicking next. Next screen for security setting, here we give passphrase, it used when we add another server in the farm. It must be strong means combination of alphabet, numbers and special character and minimum 8 characters required. Then click next.



  • After clicking next .another screen appears here we can set the port number for SharePoint Central Administration or we can choose default port number. It looks like a http://databaseserver name: port number/ .Once you choose the port number we cannot further change it. Here we can go for default port number .and we can also set the Authentication provider NTLM or kerberos .generally we are choosing NTLM. Then click on next.


  • Next screen shows the summary what we have taken. Take the screenshot of this screen for further use .this us best practices. Click next.


  • After clicking next our configuration is start.




  • Click on finish to close configuration wizard.


  • After closing SharePoint configuration wizard new window is pop for configuring SharePoint farm, click on start the Wizard.


  • In the next screen you can choose an account from which you manage all the services. By default there are 14 services available .you can un-check the services which you don’t run from this account. Then click next. Generally Managed Metadata Service, Search service application, User profile service applications are minimum recommended which should be selected.


  • In the next screen we can choose any template to create a top level site .now we can choose team site for it. Then click ok.


  • Next screen shows completion of farm configuration wizard. Click on finish. Now your central Administration is appear .



  • To see our site we are going to Application management—>manage web Application


  • Copy The URL And open in to new Tab.



  • Now Our SharePoint Site Is Up and Running.


Done  …. 🙂 🙂 🙂  Enjoy ….:)

Media Web Part in SharePoint 2010


Microsoft SharePoint 2010 Enterprise Edition has many new features useful for enterprises .One who knows all these features can save a lot of cost and leverage SharePoint for better management of assets including multimedia assets in organization.
SharePoint 2010 now also provides central repository for windows audio and video file.
One can upload this multimedia content to media\assets library and play them in browser using Silverlight media webpart
Microsoft SharePoint 2010 Media Player web part supports only following Media file Format as follows:-

  1. Windows media Audio(WMA)
  2. Windows Media Video(WMV)
  3. ISO/MPEG Layer-3 (MP3)
  4. MP4

In order to leverage this SharePoint Digital asset management feature follow the steps given below


  • Open site in browser and enter credentials .The user must be site collection administrator.


  • Go to Site Action —>More options.


  • Here number of templates are available, but now we are interesting in to create an Asset Library. So we choose Asset Library. we can choose directly from the front or we can go to library in side navigation bar then select Asset library





  • Give the Name to your Asset library, we giving the name JustRock. Then click on create button.


  • It will take few second to create a library


  • Now our library is created.


  • Click on Add new Item to add new item in your library


  • After clicking on Add new item, new window is open here we can upload our media file. Click on brows.


  • After clicking on brows button we can browse media file from our local machine.


  • As above mentioned it support only following media file :-
  1. Windows media Audio(WMA)
  2. Windows Media Video(WMV)
  3. ISO/MPEG Layer-3 (MP3)
  4. MP4

If other than this file format, we select another one its give a message Assets in this format cannot be played by the Media Player Web Part. Here we select a MPG file. So it shows the message in yellow strip.


  • Now we are going to add FLV File again it gives the message.



  • Now we are going to add MP4 file. This time it not gives any message. Then click on Ok button.



  • Wait for few second, until file upload.


  • After few second new window opens here we can put the information like title, keyword, comments, Author, time and date of creation and copy right information. Then Click on save button.



  • Now our media file is successfully added


  • Now click on media file which we have uploaded, a new pop window is open in the side.


  • Then click on play button. Now a video song is start.


Note: – Before binding the media file ensure that our “SharePoint Server publishing Infrastructure” feature is active or not. If it is not active we are not able to see video and audio web part under the media section on ribbon when we edit the page.

  • Now we want to bind this media file with a web part. Then go back to your site. And then go to Site Action —–>Edit Page.


  • Go to Editing Tools —–>insert


  • In the media section of ribbon there must be a video and audio web part. Because “SharePoint server publishing Infrastructure” feature is not activated here .So it’s not shown here. For this firstly we need to activate this feature.


  • Go to Site Action —–> Site Setting



  • Go to Site Collection Administration —–>Site Collection feature


  • Here we can see SharePoint server publishing infrastructure feature is not activated. Click on Activate button.to start your feature.


  • Now our SharePoint server publishing Infrastructure feature is activated.


  • Now again we go back to our site. Then go to Site Action —–>Edit Page


  • Go to Editing Tools —–>insert


  • Now we are able to see Video and Audio web part in media section.


  • Click on video and audio web part. After clicking we are able to see media webpart on our page .then click on click here to configure.


  • After clicking on that we see the new option in left Most corner of the screen is Change Media.


  • Click on drop down button and then click on “from SharePoint” option.


  • Then select the location of media file from here.


  • Now our media library name is JustRock .So click on JustRock and select media File then click on OK Button.


  • Now our media File Successfully bind with Media Web Part .Click on play Symbol on .it will start.


  • Now save the changes. Click on save button in ribbon. And go back to home page.


  • Click on play button and Enjoy ………………. 🙂 🙂 🙂


Thank You for your time …. … I hope you will visit this blog more time. 🙂 🙂 🙂