I have 2 tables in a set which has 4 fields each.
Table-1 is the Income Table and Table-2 is the Expense Table.
Each table has Description, Quantity, Unit Cost and Total Cost.
In my Report I have them side by side.
The Report Groups on Event Number which works fine.
Say the Income Table for a particular Event Number has 4 entries and the Expense Table for the same Event Number has 2 entries.
My problem is that the Expense item starts to print when the Income items end. See below example
-----------------------------------------------------------------------
Income Section.............................................Expense Section
Item-1..............................................................................
Item-2..............................................................................
Item-3..............................................................................
Item-4..............................................................................
..................................................................Item-1
..................................................................Item-2
-----------------------------------------------------------------------
How can I get it to print like the below example:
-----------------------------------------------------------------------
Income Section...............................................Expense Section
Item-1...........................................................Item-1
Item-2...........................................................Item-2
Item-3....................................................................
Item-4....................................................................
------------------------------------------------------------------------
You help will be greatly appreciated!
Rudy
Table-1 is the Income Table and Table-2 is the Expense Table.
Each table has Description, Quantity, Unit Cost and Total Cost.
In my Report I have them side by side.
The Report Groups on Event Number which works fine.
Say the Income Table for a particular Event Number has 4 entries and the Expense Table for the same Event Number has 2 entries.
My problem is that the Expense item starts to print when the Income items end. See below example
-----------------------------------------------------------------------
Income Section.............................................Expense Section
Item-1..............................................................................
Item-2..............................................................................
Item-3..............................................................................
Item-4..............................................................................
..................................................................Item-1
..................................................................Item-2
-----------------------------------------------------------------------
How can I get it to print like the below example:
-----------------------------------------------------------------------
Income Section...............................................Expense Section
Item-1...........................................................Item-1
Item-2...........................................................Item-2
Item-3....................................................................
Item-4....................................................................
------------------------------------------------------------------------
You help will be greatly appreciated!
Rudy
Comment