Need Help in Report
"Nasir Baig" <nasir-nkJVuyUqn/[email protected]> Tue, 28 Jun 2005 15:19:41 -0500
| Newsgroups | gmane.text.rlib.user |
|---|---|
| Message-ID | <3B90249B7FEA5040A85595B1C5C4F97D1A4FF3@gelbermail1.gelbergroup.com> |
Hi There, I am trying to develop a PHP script which is generating pdf report using RLIB. I require to make a report for YTD total data for multiple accounts. In addition to YTD total I am also required to display transactions for each account for a particular day. I have two queries. One calculates YTD total for each account and the other gives previous day's transactions for each account. It is possible that accounts may not have any transaction for this day. I want to display the output in following format : Account No 1 YTD Total Query:1 Transaction 1 Trassaction 2 Query:2 Trassaction 3 -------------------------------------------------------------------------------------------------------------------- Account No 2 YTD Total Query:1 Transaction 1 Trassaction 2 Query:2 Trassaction 3 -------------------------------------------------------------------------------------------------------------------- Account No 3 YTD Total Query:1 --------------------------------------------------------------------------------------------------------------------- Account No 4 YTD Total Query:1 --------------------------------------------------------------------------------------------------------------------- Account No 5 YTD Total Query:1 Transaction 1 Trassaction 2 Query:2 Trassaction 3 -------------------------------------------------------------------------------------------------------------------- Account No 6 YTD Total Query:1 Transaction 1 Trassaction 2 Query:2 Trassaction 3 -------------------------------------------------------------------------------------------------------------------- Account No 7 YTD Total Query:1 ------------------------------------------------------------------------------------------------------------------- As you can see some of the accounts do not have any trasaction listed. I tried to use the break feature in XML, but I am unable to display the accounts that do not have any transactions. Please suggest me how I can solve this issue. Thank you, Nasir Baig Gelber Group, L.L.C.