Re: Java program involving hssf, horizontal inversion

Yupp...
Coded...
Debugged...
Executed...
Everything worked like I wanted. I appreciate your help.

Thanks a lot,

Jake.

On 5/10/06, Paul Holm <pholm@xxxxxxxxxxxxxxxxx> wrote:

Jake,

Your report was hard to read due to formatting but it appears you want to
"horizontally invert" your results.

It may be a bit cumbersome but we have done this by using JDBC/SQL.  For
example:

Select sum(sales) as total, SUM ( case when state='AL' then sales else 0
END) as AL_Sales, SUM ( case when state='CA' then sales else 0 END) as
CA_Sales, .....
>From X.Y
Group by division


So the SQL case statement conditionally adds sales for each state and
creates a derived field for each state horizontally. Try it on a small
scenario to validate for your data.  It should work.



Thanks,  Paul