Skip to Content
0
Former Member
Sep 26, 2008 at 06:31 AM

Multi-Column

29 Views

Hello,

I would like to build a report which display, let's say, a list of products with only 2 information:

+ Product Name

+ Price

As there are only 2 information, I want to use multi-column in the page, so when it comes to the end of the page, it restarts to the begining, on a second column this is to save space in the sheet).

I used the out of the box "multi column layout", and set the number of column to 2 (catually it's 4, but it will be easier to explain).

Result is:

PRODUCT NAME.....PRICE |

PRODUCT 1..............10.00 | PRODUCT 5................30.00

PRODUCT 2..............10.00 | PRODUCT 6................40.00

PRODUCT 3..............50.00 | PRODUCT 7................20.00

PRODUCT 4..............40.00 | PRODUCT 8................80.00

Actually I would like a subtotal at the end of each column, and to report the total of the previous column on top of the next one.

I would like this:

PRODUCT NAME.....PRICE | PRODUCT NAME........PRICE

..........................................| Report:......................110.00

PRODUCT 1..............10.00 | PRODUCT 5................30.00

PRODUCT 2..............10.00 | PRODUCT 6................40.00

PRODUCT 3..............50.00 | PRODUCT 7................20.00

PRODUCT 4..............40.00 | PRODUCT 8................80.00

________________________|___________________________

...............................110.00 |.................................280.00

Do you think there is an out of the box functionnality to implement this sub total on the top and on the bottom?

thanks you very much for your help

Ahmed