How do I put multuple columns in a report

[Guest]

Hello

I am trying to create a report to look something like the below

Balances EUR GBP USD JPY
Broker 1 10.00 20.00 10.00 200.00
Broker 2 15.00 10.00 10.00 100.00
Sub TOTAL 35.00 30.00 20.00 300.00
A/c Bal 35.00 28.00 20.00 305.00
DIFF 0.00 2.00 0.00 +5.00

Instead I keep getting the following

Balances EUR GBP USD JPY
Broker 1 10.00 Broker 1 20.00 10.00 200.00
Broker 2 15.00 10.00 10.00 100.00
Sub TOTAL 35.00 30.00 20.00 300.00
A/c Bal 35.00 28.00 20.00 305.00
DIFF 0.00 2.00 0.00 +5.00

 

[mike]

Hello

I am trying to create a report to look something like the below

Balances EUR GBP USD JPY
Broker 1 10.00 20.00 10.00 200.00
Broker 2 15.00 10.00 10.00 100.00
Sub TOTAL 35.00 30.00 20.00 300.00
A/c Bal 35.00 28.00 20.00 305.00
DIFF 0.00 2.00 0.00 +5.00

Instead I keep getting the following

Balances EUR GBP USD JPY
Broker 1 10.00 Broker 1 20.00 10.00
200.00
Broker 2 15.00 10.00 10.00 100.00
Sub TOTAL 35.00 30.00 20.00 300.00
A/c Bal 35.00 28.00 20.00 305.00
DIFF 0.00 2.00 0.00 +5.00

Use the wizard to create the report. If you are still experiencing
problems, look at the control source of the field in question, there bay be
a conflict with it and the name of your label.

Regards,
M Woods,
==============
www.fruitchat.co.uk
www.software-illusions.com