Dear TDL Experts I want to sort the pending bills by bill date. There is bill name wise sorting in default. [Collection: Pending Bills] Title: $$LocaleString:"Pending Bills" Sub Title : $$LocaleString:"Name", $$LocaleString:"Date", $$LocaleString:"Balance" Source Collection : Pending Bills SRC Fetch: Name, BillDate, BillCreditPeriod, BaseClosing, FinalBalance Unique : $$Name Format : $$Name, 10 Format : $BillDate, 8 : Universal Date Format : $BaseClosing,-30 : "AllSymbols, DrCr" Client Only : Yes Keep Source: ... ;; Keep the source at Bill allocations subform Level
Hi I hv tried it. Its not possible. This table fields are in string form, So Sorting won't work on it. you may enter any year, month or date manually, those listed bills will be sorted with respect to the entered month, year or date. There s no other way to achieve this. If you have found please share with us.