Report with two columns

[Fabio Pagano]

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.

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

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.

[HighAley]

Hello.

Please, look at the attached report template.

Thank you.

[Fabio Pagano]

Thank your for the example.

I have done the task (that was more complex than my example, it was a balance in sections for accounting).

You have a great software and an incredible support.

Thank you.

[HighAley]

Hello.

We are always glad to help you.
Let us know if you will need any additional help.

Thank you.