| A complex matrix report Problem [message #124273] |
Fri, 17 June 2005 03:35 |
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
|
Senior Member |
|
|
Only concern column included.
Tab_AccountHead /*Master Table */
Col_HeadName /*PK*/
Col_AccountType /*Assist, Expense, Income, Libilties*/
Tbl_JournalBook /*Child Table*/
Col_HeadName /*FK*/
Col_CR
Col_DR
Col_JournalBookDate
I make a matrix report for Tbl_JournalBook (Only for Income)
Matrix Report Query = Select J.Col_HeadName, J.Col_DR, J.Col_JournalBookDate
From Tab_AccountHead A, Col_JournalBookDate J
Where J. Col_HeadName = A.Col_HeadName
AND A. Col_AccountType = ‘Incomce’
Matrix Report Row = Col_JournalBookDate
Matrix Report Col = Col_HeadName
Matrix Report Cell Field = Sum (Col_RD)
This report work well. But I also need following:-
I want to add a single column “Sum(all Expense(i.e. where A. Col_AccountType = ‘Expense’))” after last Col_HeadName and want total = sum(all Col) – sum (all Expense)
Please advise how to manage it.
Either in matrix report or in query of report.
Wishes
Jawad
To tried to summarize my problem for experts ease, if it still not understandable please advise to give more details.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
