Report with two columns
Posted: Mon Feb 04, 2013 1:43 pm
Good morning.
I need to print a balance report (accounting) with two columns, where the left column contains the "Active amounts" and the right column contains the "Passive" amounts (these are accounting concepts).
Eg.
I have a single datatable where i have the following columns:
"Type: 0=Active/1=Passive"
"Accounting code (eg. "A", "B")"
"Amount"
So, according to the example above, i have the following rows in the datatable:
0 A 100
0 B 20
0 C 30
0 D 10
0 E 20
1 F 50
1 G 30
1 H 35
1 J 28
1 K 43
I need to print in the left column (that may need several pages) the records of type 0 (Active) and in the right column, restarting from first page, the records of type 1 (Passive).
Do you have any suggestion on how i may obtain this?
Thank you.
I need to print a balance report (accounting) with two columns, where the left column contains the "Active amounts" and the right column contains the "Passive" amounts (these are accounting concepts).
Eg.
Code: Select all
Active | Passive
A 100 | F 50
B 20 | G 30
C 30 | H 35
..(others).|.(others)..
----- new page -----
D 10 | J 28
E 20 | K 43
"Type: 0=Active/1=Passive"
"Accounting code (eg. "A", "B")"
"Amount"
So, according to the example above, i have the following rows in the datatable:
0 A 100
0 B 20
0 C 30
0 D 10
0 E 20
1 F 50
1 G 30
1 H 35
1 J 28
1 K 43
I need to print in the left column (that may need several pages) the records of type 0 (Active) and in the right column, restarting from first page, the records of type 1 (Passive).
Do you have any suggestion on how i may obtain this?
Thank you.