I want to change the “order by” priority in a report. Is it possible? I need this: order by inventdim.wmslocationid, salesline.itemid, but because the inventdim table is the last node of the report, end of the sql statement is always this: order by salesline.itemid, inventdim.wmslocationid
If I swap the table order, the result of the report is wrong… Can I solve this some X++ code?
Thanks in advance