order by priority

Hi all,

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

Remove the fields from the sorting node of individual data sources and add them to OrderBy Node(in the required order).