Sage 100

Sage Intelligence 4.50 - I swear that I've seen this issue in socialcast but can't find the thread...have 3 UDF fields in a connector and subsequent report. The data shows on sheet one with these UDFs populated. Added to the pivot table but no data shows. I've removed them from pivot, relinked, add them back and relinked and they still don't show on the pivot.

Fixed - here's how: The data was a string UDF (a time actually in format ##:##) Added an expression to the connector of: If ((UDF_TIME) = """", 0, TimeValue(UDF_TIME)) Added this expression to the columns in the report, then the pivot table Changed the format of the field to Time HH:MM You may not need the 'If' statement, but I added in case there were fields missing this data so that I didn't see the an Excel error.