Creating a dashboard from SharePoint list using Excel services

Comments

Post a Comment

Popular posts from this blog

Volatile function error for SharePoint calculated field current date

  Today's Issue: Volatile function error for SharePoint calculated field current date While creating calculated column to find date difference, I encountered this error. Here I have provided the resolution to fix it, Create a  new column  called  Today  (Single line of text). Create a  calculated column , name it anything you want, say ' CurrentDate '. In the  formula , insert the column you created previously ' Today '. Set the data type to ' Date and Time '. Set the Date and Time format to ' Date Only '. You can even select Date & Time if you would want to use hours/minutes as well. Now  delete  the ' Today ' column you created in first step. Don't worry, just go ahead. Add the 'CurrentDate' column to your view and check the value. You should see today's date in there. Modify the formula as required, you can use the column Today just like the function [Today] without any issues. Same approach could also be used for [Me],...
Read more

Search not working in federated SAML authentication SharePoint site

  Situation : Created a web application and chosen “Default zone” for Trusted Identify Provider authentication “iTrust” – (SAML Authentication) Note: Trusted Identity Provider Authentication enables federated users in this Web application. This authentication is Claims token based and the user is redirected to a login form for authentication.   Issue: Site is working fine but “Search” didn’t work. When checked for the reason, found that the default zone should be windows authentication which makes ‘Search” work. Resolution: -          -   Need to create standard default zone windows authentication (Though this is not required – as the site created is for federated authenticated external users with SAML authentication). -           -  Then extend the windows default zone application into Trusted Identity provider “Extranet/Any available zone” site.   Step1: Default zone windows authenticat...
Read more

Unable to deploy wsp pacakage - Timer job and cache issue

 Sometime back in my project , I couldn't deploy wsp packages anymore. After some analysis found there are lot of one time job were running and it was blocking wsp deplopyment. Here I have provided the steps to resolve it, -   In Central Admin checked in Farm Solution Management the status was stuck on Deploying​ -   Stopped the SharePoint Admin and SharePoint Timer services       -   Checked and found multiple One-time jobs​, deleted those using the scripts below: -           Get-SPTimerJob | where{$_.DisplayName -eq $null} | foreach-object {$_.Delete()}Get-SPTimerJob | where{$_.schedule.description -eq "One-time"} | ForEach-Object{$_.Delete()} -           Checked if the timer service is ON using the script -           $farm   = Get-SPFarm -           $disab...
Read more