Hi, I'm wondering how to approach crosstab queries with the entity engine. That is, I want to turn data from a row into a column heading.
if the entity is something like: salesperson(char 20), month(number), total(number) and I want a query like SELECT salesperson, (SELECT SUM(total) from sales where month = 1) as 'JAN', (SELECT SUM(total) from sales where month = 2) as 'FEB', . . . . . . (SELECT SUM(total) from sales where month = 12) as 'DEC', (SELECT SUM(total) as 'GRAND Total' reading the entity engine cookbook, I see a way to to SUMs and other functions, but not sub-selects. and also I have a case where I would have to get the column names themselves using a query. For this, I would be limited to JDBC, I take it? Tim McGuire Integral Business Solutions phone: (651) 259-1008
