Wednesday, October 13, 2010

Setting SharePoint Form Fields Using Query String Variables

Nice article on how to set form fields values using query string, click here

how to set hyperlink url and description simutaneously in sharepoint designer workflow

use the following format {url}, {description}

NB:leave a space after the comma

Tuesday, July 13, 2010

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)

When using reporting services in Sharepoint Integrated Mode, you may encounter the error. This is to the fact that the datasource link is somehow broken on the reports.
To solve this:
1. Go to the reports folder on Sharepoint (where all the reports are published)
2. Edit data source on each report and link the datasource back.

This should sort out the issue.

Thursday, July 1, 2010

Showing a SharePoint calculated column in Infopath

Here is a small tip about how to display a Sharepoint Lists' calculated column in infopath 2007.

1. Create your lists in Sharepoint with a calculated column (Field1&Field2)
2. In Infopath 2007, create a data connection use XML file use the following (http://servername/_vti_bin/owssvr.dll?cmd=Display&List={GUID of the Lists}&XMLDATA=TRUE
3. Choose this data connection in your drop down lists, and choose your field.

Sunday, June 13, 2010

Click and Drag Outlook email to SharePoint 2007 explorer view

Click and drag to SharePoint Explorer view is very helpful instead of using the upload multiple documents. But it seems that this does not work fine if you are running SharePoint 2007 on Windows 2008.
For all those who are struggling to get this to work. These are the steps:
1. Upgrade your Os to the laltest Service Pack
2. Install Sp2 for your Outlook 2007
3. Install Software Update for web folders Folders http://www.microsoft.com/downloads/details.aspx?familyid=17C36612-632E-4C04-9382-987622ED1D64&displaylang=en
4. Install the folllwing fix http://support.microsoft.com/default.aspx?scid=kb;EN-US;968858..

note that this only applies to Office 2007. I haven't found a fix for Office 2003.
I hope this helps..