Formatting SharePoint Data in SQL Reporting Services Report20 Sep 2010 | SharePoint 2007, SQL Server Reporting Services
Depending on the field type, SharePoint may format the data as “#n;Value”. Not very pretty. I found this solution somewhere, but don’t remember where. You can add the below function to your SSRS report by going to Report (when on the Data or Layout tab in Visual Studio/Business Intelligence Development Studio) –> Report Properties –> Code.
Function GetNameFromSP(pFullID As String) As String Dim strRet As String Dim iPos As Integer If pFullID = NOTHING Then Return "" If pFullID = "" Then Return "" iPos = Instr(pFullID, ";") If iPos < 1 Then Return pFullID Return Mid(pFullID, iPos +2) End Function
To use this code in an expression, type: