Here is what I used and it worked great:
select
gl_account.id as GLAcct,
gl_account.descr as GLDesc,
case when gl_ledger.transaction_date between '2014-01-01 00:00:00.000' and '2014-01-31 23:59:59.000' then sum(gl_ledger.amount_n) else 0 end as Jan,
case when...