I am trying to use getportalreportdatasubset() to get data from the portal report into my SAIL form.

we are on 7.7, so the function will not help. I tried tostring(lag()) and kept the field type as normal text. So now in the portal report i see this field value as 22:03:01 and i can get the data into my SAIL form through the function as well. However since its a text now, sorting doesn't work correctly on this column, be it in portal report or on my SAIL form

we are on 7.7, so the function will not help. I tried tostring(lag()) and kept the field type as normal text. So now in the portal report i see this field value as 22:03:01 and i can get the data into my SAIL form through the function as well. However since its a text now, sorting doesn't work correctly on this column, be it in portal report or on my SAIL form