Hi all,

I have a report with three fields A,B,C. Supposing D is a field calculated based on A and B. Now i want to sort the report based on field D but D should not be shown in the report. How can i do it? Any help would be deeply appreciated.

Just calculate D in the session script, declare it as external and use it in the report input fields, with sort order. Doesn't matter if you use it or not in the layouts.

If by calculated field , u mean filed derived from calculations on aggregations of fields, top down grouping (http://www.baanboard.com/baanboard/showpost.php?p=105479&postcount=3) will help u .

For line level calculated items,adding D fields in sort order will be sufficient.