omfgppc - 2008-09-18

gmoskowitz wrote: Mike,

From your description it sounds like you are looking at the application window and not the printed report.

The SELECT statement that gets executed to build this display grabs the data in separate columns of the output. The xTuple ERP application that calls the SELECT then rearranges the results to build the indented display that you see, including putting the order and line numbers in one visual column and the customer and item numbers in another.

I''ve attached the source file that holds this query.

Gil -- Read more at http://www.xtuple.org/phpBB2/viewtopic.php?t=2800