Displaying Master Record in report
Displaying Master Record in report
How we can solve the problem of not displaying the master record only when there is no any data in detail record in Group Above, Group Left or Matrix Report? Whereas the master record exists in the master table.
Yes I have used it. But in this situation I mean that in a customer ledger I select customer's name, address etc from customer table, calculate his opening balance from journal table, where all transactions of the the customers are stored, and the datewise transaction of that customer are selected from the journal table. Now if a customer have no any transaction on or after a given date whereas he has his opening balance. But when i run the report it does not diplay the name, opening balance of that customer because there are no any transactions after that given date in the journal ledger. My question is that it should display the name, address and opening balance of that customer.
Just UNION this Query with the MAIN Query Which Calculate the Balance, Opening or Transaction Balance
UR QUERY HERE
UNION ALL
Select Sysdate, Party_Code, Party_Title, 0 Balance,
from party_table
Where Party_code = <Parameter>
I'm Asuming that u have the number of Columns (like written Above) in ur Query..
Inshallah it Will Solve ur problem.....
UR QUERY HERE
UNION ALL
Select Sysdate, Party_Code, Party_Title, 0 Balance,
from party_table
Where Party_code = <Parameter>
I'm Asuming that u have the number of Columns (like written Above) in ur Query..
Inshallah it Will Solve ur problem.....
Who is online
Users browsing this forum: No registered users and 1 guest