I am sorting a foundset and writing these to a related foundset that will be used in the printed Velocity. The sort order of the related foundset is getting lost in the report.
It is quite a complex sorting algorithm; I could add a simpler sort column in the printing foundset but I cannot figure out how to get the #foreach in the Velocity template to utilise a sorted order.
Any help would be much appreciated, thanks.