Working on a report that will show gl summary data by account, per year, per month.
Issue is when an account has no activity for a specified year and month, it doesn’t display since there is no records. However, I want to show a record with $0 balance for that specified year and month.
Line Item detail account data table has following columns;
account, trxdate, trxAmt, Year
If account 123 has records for Oct and Dec, but none in Nov, I want three records to render for account 123, sum by month(trxdate) and Year
Account | TrxDate | TrxAmt | Year
123 Oct $100 2011
123 Nov $0 2011
123 Dec $100 2011
How do I get a sum of TrxAmt by month(period) for months with no activity?
Thanks for your assistance.
awaria
Issue is when an account has no activity for a specified year and month, it doesn’t display since there is no records. However, I want to show a record with $0 balance for that specified year and month.
Line Item detail account data table has following columns;
account, trxdate, trxAmt, Year
If account 123 has records for Oct and Dec, but none in Nov, I want three records to render for account 123, sum by month(trxdate) and Year
Account | TrxDate | TrxAmt | Year
123 Oct $100 2011
123 Nov $0 2011
123 Dec $100 2011
How do I get a sum of TrxAmt by month(period) for months with no activity?
Thanks for your assistance.
awaria