Crystal Reports cost cannot show in 2 columns

Message

< ="Content-" content="text/; charset=utf-8">< name="ProgId" content="Word.">< name="Generator" content="Microsoft Word 11">< name="Originator" content="Microsoft Word 11"><>

Now I facing some difficulty on create the crystal report.

Kindly please refer to example as below: 

In Database data show as below:

StockCode                   warehouse                    cost

KW1011                         W1                          20.00

KW1011                         W2                          25.00

KW1020                         W1                          18.00

KW1020                         W2                          22.00

Now my report design as below:

StockCode                   cost
for Warehouse 1 (W1)      cost for
Warehouse 2 (W2)

KW1011                                 20.00                                       25.00

KW1020                                 18.00                                       22.00

I fail to create the report because the cost cannot show in
2 columns by ware house. 

The data show in report still same as database.

Anyone know to solve my issue?

Kindly please advice.

Thank you.

Edited by skyfox - 05 Jan 2010 at 5:55pm