Hello again!

I was wondering if anyone can help mw with this one: I have a report in Reportmaster called 'Key Accounts' with the following columns from left to right:

Customer ID
Name
CY-YTD Sales (Current Year-Year To Date Sales)
LY-YTD Sales (Last Year-Year To Date Sales)
$ Change (Difference between the two above)
On Order Amount
LY Total Sales (Last Year Total Sales)
Business Due (Calculated colum: 'LY Total Sales' minus 'CY-YTD Sales 'minus 'On Order Amount')

Account Managers running this report will specify a 'Report Group' which shows them only their customers.

For anyone familiar with Reportmaster, the main file for this report is a Report Back called 'On Order RB'. It also pulls information from the 'AR Customers' table.

The 'Order RB' (Order Report Back) pulls the following from the 'OE Order Headers' table:

Customer
Total Order Amount

The only record selection criteria I was able to find in the 'On Order RB' was "Order Complete=0" - which, I assume, means to only display orders that haven't been completed.

My question at this point is:

Can I start by using a Adagio Composite Table that contains both the 'AR Customers' table and the 'OE Orders Header' table? Is there such a thing? What are the differences between some of the composite tables (for instance 8.0A and 8.0C)?
Would I have to calculate the YTD and Total sales amounts using calculated colums or does that information already exist in some SR tables? I looked, but I haven't been able to find anything that would do that for me.

Thanks in advance.

Regards,

Andre