|
From: Nasir B. <na...@ge...> - 2005-06-28 20:17:34
|
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
=09
Transaction 1
Trassaction 2 Query:2
Trassaction 3
-------------------------------------------------------------------------=
-------------------------------------------
Account No 2 =
YTD Total Query:1
=09
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
=09
Transaction 1
Trassaction 2 Query:2
Trassaction 3
-------------------------------------------------------------------------=
-------------------------------------------
Account No 6 =
YTD Total Query:1
=09
Transaction 1
Trassaction 2 Query:2
Trassaction 3
-------------------------------------------------------------------------=
-------------------------------------------
Account No 7 =
YTD Total Query:1
-------------------------------------------------------------------------=
------------------------------------------=20
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.
|