Hello
I have made a query and in the script added some more data.
Based on the added data I would like to set the order of lines/group by...
Can I make this somehow ? I tried mathings, but the "group by" is preferably stated from the query.
Thanks for help

a bit more clarity is need........... and what do you mean by added some more data ??

is that a program script or just easy sql + report script ( for additional data)

It is easy sql and The report script only

1) you might want to look at the following posts and work your way out

http://www.baanboard.com/baanboard/archive/index.php/t-28356.html

http://aridhol.kudos.be/baanboard/showthread.php?p=172720

Or

2) recall your report from the report script and send the detail data and Extra data to and and kill the 1st report

lets say ... your report is 'A.rpt' , copy it to A.rpt_1 ( not sure if you need create a copy , might as well work with same report , you can try that out)

when you run the easy SQL ---> A.rpt opens up and the report scripts run

open the A.rpt_1 with help of brp fuctions and send the detail data and extra data from A.rpt to A.rpt_1

and kill A.rpt on after.program of A.rpt's report script

FloW:

Easysql --> report + extra data --> report 2

Thanks for hint. I will try to work out the correct syntax, as I have not experiences with that.
;)