Archive for the ‘SharePoint’ category

Recently, I was asked to “mirror” someone’s access levels, but had not the budget to buy some of the professional-level administration tools out there. After a few trips to Google and Bing, I finally came up with this quickie: Use SharePoint Designer to create a SOAP Service connection to the UserGroup.asmx web service in SharePoint […]

Just recently some end users noted that subsites on our SharePoint (WSS 3.0) simply gave the end user the following error: Even my Central Admin was down with the same problem! After modifying my web.config to allow more detailed error, (I did this first on my SCA to avoid showing detailed errors to end users) […]

I wanted to create a development version of our Production SharePoint site so I can experiment with custom applications we are developing. This full backup and restore process would also give us practice on disaster recovery. While most of the backup/restore process went smoothly, I found that the core.css style was missing. After much searching […]

I found a great article on Path to SharePoint blog that uses a Javascript trick and calculated columns to display HTML. I was trying to create a more integrated SharePoint list to manage my projects. I created a custom list that lists out each of the projects I’m currently working on and wanted to associated […]

Here’s a lil trick I learned for calculating the Month Name and Year of an item in a SharePoint custom list so you can group by month and year. Create a new calculated column for your SharePoint List Use the following formula: =TEXT([Your Date Field], "MMMM") & "-" & YEAR([Your Date Field]) You can use […]

In my blog post Connecting Reporting Services to SharePoint, I listed out some resources for getting SSRS connected to a SharePoint list. If you chose to use the last link I mentioned for forming your query in SSRS… Querying SharePoint List from Reporting Services returns only “not null” columnsMaybe some more advanced XML Querying language […]

Recently, some site owners in my organization mistakenly clicked the “X” button on the top-right corner of a web part (while the page was checked out and in edit mode) to be the button to use to close out of the edit mode. They were frantic in coming to me to help them restore hours […]

I found a sweet article by Mark Wagner that shows you how to hide the “View All Site Content” link in SharePoint. Note, this does not secure the View All Site Content page, just hides it from the end user. If you are okay with that, then read on…   How To: Hide/Remove the View […]

Circumstances are always such that you don’t have the time it takes to learn the best way to do things, especially when your boss or your company’s executives don’t realize the amount of effort it takes to create what they think of as a “simple report” In a past post I wrote about Connecting Reporting […]

UPDATE (2/9/2012): Found official documentation at Microsoft for formulas and functions compatible with the Calculated Fields! http://office.microsoft.com/en-us/windows-sharepoint-services-help/CH010065006.aspx A great way to fine tune a list in SharePoint is to use calculated fields, but there doesn’t seem to be comprehensive (and free) documentation on what functions work within a SharePoint Calculated Field. Since I haven’t yet […]