SSRS – Vertical merge cells in Details rows

I have stored procudure which returns some data like this:

Trade mode;Area;Production place;Commodity;Reseller;Min_sell_price;Max_buy_price;Trans_count;Volume;avg_price;change_avg_price;last_trade_price;last_trade_volume
"Trade mode1"; "Area name1"; "Place1"; "Commodity1"; "No";  "33601"; "33601"; "1"; "1200"; "33601"; "+28"; "33601"; "1200"
"Trade mode1"; "Area name1"; "Place1"; "Commodity1"; "Yes"; "-";     "33601"; "0"; "0";    "33601"; "+28"; "33601"; "1200"
"Trade mode1"; "Area name1"; "Place2"; "Commodity2"; "No";  "35000"; "35000"; "1"; "180";  "35000"; "0";   "35000"; "180"
"Trade mode1"; "Area name1"; "Place1"; "Commodity2"; "Yes"; "-";     "35000"; "0"; "0";    "35000"; "0";   "35000"; "180"

And I need to create the report is SSRS 2008 R2 which looks like this:

Report example

I have no idea, how to merge cells in columns “Maximum buyer price”, “Average price by commodity”, “Average price change”, “Last deal price”, “Last deal volume”. I would be grateful for any suggestions.

Answer

I don’t see why you would need merged columns in your example. You can increase the height of the cells if you need to fit text onto more than one line.

Also if you use borders carefully you can give the appearance of merged cells even though there are not.

I hope this helps

EDIT

I see your example has changed. Insert a table into the cells you want split vertically So price range would be a table inside a table. As would traders.

Advertisement

Answer