SharePoint MCP

Steps to Implement Cascading Drop Down. Follow the steps in SharePoint UI. (Browser) Create a custom List Name it as City List. and Rename Title as City , Insert two items into it. Create a Custom List name it as District list and rename Title as District , Create a Column by Name City, of type look up. Get information from City List , City Column . And few items with corresponding to city column. Create a Region List name it as Region list and rename Title as Region , Create a Column by Name City , of type look up . Get information from City List , City Column . And Create a Column by Name District, of type look up . Get information from District List, District Column. Now in Region List, From the Ribbon Click on List Tools. Click on customize form .Form template will be imported to InfoPath. Right Click on District Dropdown, Select Dropdown List box Properties, Select Get choices from external data

Using Reporting Services in Sharepoint 2010. What is SSRS ? SQL Server Reporting Services 2008 (SSRS) is a feature included in the SQL Server 2008 product. SSRS is used to design, develop, test, and deploy reports. When SSRS is installed, there are two databases i.e. ReportServer$SQLSTANDARD and ReportServer$SQLSTANDARDTempDB created by default. You can also configure these databases manually using the Reporting Services Configuration Manager. Also a developer-centric tool called Business Intelligence Development Studio (BIDS) is installed automatically, which can be used through Visual Studio 2008. BIDS uses Report Designer, a developer tool for building complex reports. Report Builder 3.0 on the other hand provides a simpler user interface for creating reports, directed primarily at business users rather than developers. Prerequisite to integrate SSRS with SharePoint 2010 . 1) Download and Install the prerequisite SSRS 2008 R2 Add-in for SharePoint along with other re

Power Shell  Script to get orphaned users from SharePoint Site. Who are orphaned users? Orphaned users are those who are disabled/removed from Active directory. avoi d user to still exist in the SharePoint People picker. If we want delete few users only then browse to following url of your site delete user from there. http:// <SharePoint Server Name> : <Port No> /_layouts/people.aspx?MembershipGroupId=0      using above URL We get all the list of users who exist in Site Collection. We can even delete any user from this URL, but it will remove from the complete Site Collection  We can also query the users alternatively from SQL server  1 : Open SQL Server Management Studio SELECT * FROM [Sharepoint_Content _DB] .[dbo].[ Detailed User information ] WHERE tp_Login='DOMAIN\UserID'         2: record the tp_Id value , based on this  we can get user reference . 3 : Go to http://< Site_Collection_Address >_layouts/userd