[Rlib-users] Need Help in Report

[Nasir B. <na...@ge...>]

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.