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.