Posts

SQL Server Query Statement Get Last Previous Working Day

SELECT DATEADD ( DAY , CASE DATENAME ( WEEKDAY , GETDATE ()) WHEN 'Sunday' THEN -2 WHEN 'Monday' THEN -3 ELSE -1 END , DATEDIFF ( DAY , 0 , GETDATE ()))

'RSClientController' is undefined

Try this , <system.webServer> <handlers> <add name="Reserved.ReportViewerWebControl.axd" path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" resourceType="Unspecified" preCondition="integratedMode" /> </handlers> </system.webServer>

SharePoint 2010 Packaging Master Pages and Page Layouts with Visual Studio 2010

Packaging Master Pages and Page Layouts with Visual Studio 2010 Deploying a custom master page in SharePoint 2010  

SharePoint 2010 Chart Web Part Issue with Service State

Error : Microsoft SharePoint Server State Service could not find a state service application bound to the default state service application proxy "state service" associated with the current web application. Or Unable to Render Chart Web part: Solution : It works for me 1. Remove "State Service" and also "State Service Proxy" along with associated data from Central Administration 2. Open SharePoint Power Shell run following commands:    $serviceApp = New-SPStateServiceApplication -Name "<StateServiceName>" New-SPStateServiceDatabase -Name "<StateServiceDatabase>" -ServiceApplication $serviceApp New-SPStateServiceApplicationProxy -Name "<ApplicationProxyName>" -ServiceApplication $serviceApp -DefaultProxyGroup 3. Enable Session State , run following command: Enable-SPSessionStateService –DefaultProvision 4. Modify the web config of that specific web application <pages enableSessionState...

SharePoint 2007 workflow session state is not available

http://sharepointpolice.com/blog/2010/04/30/%E2%80%9Cthe-form-cannot-be-displayed-because-session-state-is-not-available%E2%80%9D-in-sharepoint/  

Telerik DatePicker Bind with Database Datetime field

<telerik:RadDatePicker ID="ToDate" runat="server" DbSelectedDate='<%# Bind("ToDate") %>'  >  <DateInput ID="DateInput1" runat="server" DateFormat="MM/dd/yyyy" DisplayDateFormat="dd/MM/yyyy">  </DateInput>  </telerik:RadDatePicker> DbSelectedDate : This property don't use to show but it will work

PowerPivot for SharePoint

Plan a PowerPivot Deployment in a SharePoint Farm Install PowerPivot for SharePoint on a New SharePoint Server Install PowerPivot for SharePoint on an Existing SharePoint Server Repair (PowerPivot for SharePoint) Connect a PowerPivot Service Application to a SharePoint Web Application PowerPivot for Microsoft Excel® 2010 Download PowerPivot