I'm attempting the same thing, did you ever find a fix?
No, I dont believe there is a way to use custom properties on reports. It would seem possible based on SQL, after all the custom properties reside in the database, right? However, the developers have not created an interface to link the two things together _that I know of_ anyway. :(
You can do this by creating a report of "current status of nodes, interfaces etc." then select the "Custom Pollers (current status)/custom Node Pollers/Poller name" along with the other fields you require.
The trick to making this work is to then filter the records "where Poller name is equal to [put serial number poller name here]"
This will generate the report you are looking for, however the best way to do do this is with an SQL report, and write the query manually. This should get you what you want:
SELECT NodeID, NodeName, CAST(Status AS varchar) AS Serial_Number, FROM
SELECT TOP 10000 Nodes.NodeID AS NodeID, Nodes.Caption AS NodeName, CustomNodePollerStatus_CustomPollerStatus.Status as Status
FROM Nodes INNER JOIN CustomPollerAssignment CustomNodePollerAssignment_CustomPollerAssignment
ON Nodes.NodeID = CustomNodePollerAssignment_CustomPollerAssignment.NodeID
INNER JOIN CustomPollers CustomNodePollers_CustomPollers
ON CustomNodePollerAssignment_CustomPollerAssignment.CustomPollerID = CustomNodePollers_CustomPollers.CustomPollerID
LEFT JOIN CustomPollerStatus CustomNodePollerStatus_CustomPollerStatus
ON CustomNodePollerAssignment_CustomPollerAssignment.CustomPollerAssignmentID = CustomNodePollerStatus_CustomPollerStatus.CustomPollerAssignmentID
WHERE CustomNodePollers_CustomPollers.UniqueName = '[put serial number poller name here]'
ORDER BY NodeName ASC