Formatting SharePoint Data in SQL Reporting Services Report

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.

To use this code in an expression, type:

=Code.GetNameFromSP(Fields!MyField.Value)

Leave a Reply