SharePoint By Gaurav Goyal

I wanted to create a report in which I have created a Parameter called "User Name" , Which shows all users from SharePoint list. Now I marked this parameter as Multi value selector. But I am not able to use values of this parameter in SSRS report because this report uses CAML Query not SQL query. When I select 1 or more users and click on 'View Report' button. It gives me an error : Cannot add multi value query parameter 'Users' for dataset 'TSADataSet' because it is not supported by the data extension. (rsErrorAddingMultiValueQueryParameter) So I used this parameter in filter option of Data Set. Now it is working fine. I just followed these steps : Create multi-value parameter as you want. Right click to “ your dataset ” then click on “ Dataset Properties ”. In Dataset property form, Click on “Filters” and add expression (Field) then select Operator (Select “In” operator in case of multivalue parameter) then select value (Click on form

Microsoft released 10 new SharePoint themes you can download these theams from : Download them from Microsoft

For Backup :     http://technet.microsoft.com/en-us/library/cc287967.aspx     For site collection backup stsadm -o backup -url <URL name> -filename <file name> [-nositelock] [-overwrite]   For Restore : http://technet.microsoft.com/en-us/library/cc288929.aspx   For site collection restore   stsadm -o restore -url <URL name> -filename <file name> [-hostheaderwebapplicationurl] <Web application URL> [-overwrite]   To Take Backup of Site C:\Progra~1\Common~1\Microsoft Shared\Web Server Extensions\14\BIN> stsadm -o backup - url http://testserver/sites/sitename -filename c:\backup\bk.dat    To Restore Whole Site C:\Progra~1\Common~1\Microsoft Shared\Web Server Extensions\14\BIN> stsadm -o restore - url http://server/sites/newsite -filename c:\backup\bk.dat If you want to overwrite existing web site then use -overwrite .    

If you want to remove "I like It" , "Tags & Notes " Then just follow these steps : Open Central Administration Click on System Settings Click on Manage Farm Features (_admin/ManageFarmFeatures.aspx) Deactivate the Social Tags and Note Board Ribbon Controls OR You can deactivate this feature by Power shell command : SharePoint 2010 Management Shell Disable-SPFeature –Identity SocialRibbonControl

First, increase the Maximum Upload Size for a specific web application. Go to the Central Administration > Application Management > Web Application General Settings Specify the new maximum upload size for your webapplication. For now, we are setting it to 256MB. It could be even set upto 2GB. Your second step should be to try increasing your default chunk size of large files by trying this STSADM command: Stsadm.exe –o setproperty –pn large–file–chunk–size –pv        This basically denotes the chunk of data that can be read from SQL Server at one time.     The -pv which determines the property value stands for the upload size in bytes (B).     It could be set to a maximum of 2GB i.e. (2,147,483,648 B).     Do an IISRESET Next, in web.config file of your particular web application, under the httpRuntime tag in system.web section, increase the upload limit to match the value that you set earlier in central administration. You also need to add the execution timeout to allow mo

Let’s say you have a control on your page that you want only a certain group of users to see. Fortunately, SharePoint has a built-in control that lets you hide controls to which users do not have the necessary permissions.  This control is the SPSecurityTrimmedControl. <Sharepoint:SPSecurityTrimmedControl runat=”server” Permissions=”ManageLists”> Place your control(s) here </SharePoint:SPSecurityTrimmedControl> All you have to do is wrap your control with this security control and set the correct permissions in the Permissions attribute. The Permissions attribute, when used in Visual Studio or Designer, will have intellisense and will be filled with the following properties obtained from http://msdn2.microsoft.com/en-us/library/microsoft.sharepoint.spbasepermissions.aspx .  Whatever permissions you specify will be required by the user in order to view the control(s) inside of the SPSecurityTrimmedControl:   Member name  Description EmptyMask

Enabling a Button on the Ribbon Based on Selection A lot of people have asked me how to create a button which enables if and only if a single item is selected. This isn’t something we have out of the box, but the code to get this functionality is pretty simple. I’m going to assume that you’re generally familiar with SharePoint, CustomActions, and customizing the Ribbon – if that’s not the case, you’d probably be better off researching those things before delving into this. Basically, the enabling behavior all boils down to the following few lines of code: EnabledScript = " javascript:function singleEnable() {   var items =     SP.ListOperation.Selection.getSelectedItems();   var ci = CountDictionary(items);   return (ci == 1); } singleEnable(); " What this does is query to get the dictionary of selected items, and if the size of the dictionary is 1 it returns true (enable), otherwise it will return false (disable). Technically,