Month: November 2008

Set the Default Value in a DateTime Field When Using a Default Date Value

When adding a DateTime field to a list, you have the option of setting a Default value of Today.  However, this will make everything default to a 12AM Time.  By using the Calculated Value field, we can specify “Today+”08:00 AM” and now the field will default to Today’s date @ 8:00am.  We can also add additional days to the default date, in case we’re creating things like tracking tickets with a follow up date,  by using this method we can do things like adding an additional day or additional week by using Today+7 to put it into next week, or Today+1 to calculate a follow up of tomorrow. But lets say you want to only follow up on weekdays, now we get into some logic, and that’s where the WEEKDAY function comes in…. Day Weekday Result Sunday 1 Monday 2 Tuesday 3 Wednesday 4 Thursday 5 Friday 6 Saturday 7   So, If we enter something on a Friday, It should default to the following Monday:  In that case we’d need to add some logic into the Calculated Value field to take the weekdays into account, where if today is Friday, add 3 days, if today is Saturday, add 2 days, and if Today is Sunday or a regular weekday just add 1 day, which would look like this:   =IF(WEEKDAY(Today) =  6, Today+3, IF(WEEKDAY(Today)=7, Today+2,Today+1)) That way, the...

Read More

SharePoint with Reporting Services Error–Cannot get Role Manager

Recently I set up Forms Based Authentication on a SharePoint 2007 (MOSS) site with Reporting Services working in SharePoint integration mode.  It seemed as though things were working correctly.  However, after a couple of days we got some reports from the users that they are getting following error while running their Reporting Services subscriptions: The permissions granted to user Provider:ID’ are insufficient for performing this operation. All permissions are given using role provider groups. Permissions are still working for all other users in the same group as this user. There is nothing in SSRS log except “<SSRS>.Utilities.AccessDeniedEception”. But in...

Read More