showing column groups data in row - SSRS 2008

See more:

SSRS

BI

reporting

Hi,

I am creating reports using SSRS 2008.

I have a report like as below,

+-------------------+------------------+
| Currency: GBP     | Currency: INR    |
+--------+----------+------+-----------+
| ID     | Amount   |ID    | Amount    |
+--------+----------+------+-----------+
|S2001   |  478.89  | S492 |  23567.8  |
|--------------------------------------|
|S345    |  456.7   | S98  | 9876.0    |
|--------------------------------------|

I am doing Column Group by Currency.

I wants to display report such that Currency group should comes in row(one by one); not next to each other.

The final report should look like below,

+-------------------+
| Currency: GBP     |
+--------+----------+
| ID     | Amount   |
+--------+----------+
|S2001   |  478.89  |
|--------------------
|S345    |  456.7   |
+-------------------+
| Currency: INR     |
+--------+----------+
| ID     | Amount   |
+--------+----------+
|S492    |  23567.8 |
|--------------------
|S98     |  9876.0  |
|-------------------|

I don't wants to use Row Grouping by Currency.

Any alternative approch would be helpful.