Hi,

I'm using an Interactive Table component in a report, however the data is obtained from a database, and all records have some missing data ('properties').

The users want to be able to sort the data, however I've found that if the first record piped to the Interactive Table component contains 'nulls' in certain properties or the properties aren't defined, the Interactive Table classifies the property as a string, and sorts it as such (resulting in much frustration when 0.5, 2, and 10 are ordered 0.5, 10, 2).

Is there a way to specify what the Column types are in the Interactive Table (the Javascript to create the table is created by the component from what I can tell)?

Alternatively (and this is a fudge), could I pipe a "dummy" record into the component to create the correct property types, and then hide/not display the record? (I'd rather not do this approach unless I really cannot avoid it).

For an example, I've created a protocol which creates an Interactive Table where the sorting doesn't work correctly (on property 2 & 3 - due to PP classifying them as "Strings"), and then enabling a Custom Manipulator corrects the searching (however, I'd not want to see this record).

Many thanks for any assistance,

Rob