reporting services - Controlling row group in ssrs -

i converting crystal report ssrs , need group variable. grouped variable , report looked fine except 1 thing. consider following grouped section (row grouping)

+---------+------+----------+ | section | name |  number  | +---------+------+----------+ |       1 | aaa  | 111-1111 | |         | bbb  | 222-2222 | |         | ccc  | 333-3333 | |       2 | ddd  | 444-4444 | |         | eee  | 555-5555 | +---------+------+----------+ 

the thing trying achieve have section number heading instead of column , not column group talking about. report trying achieve move section heading each group , report like

+-----------+----------+ | section   | 1        | |name       | number   | | aaa       | 111-1111 | | bbb       | 222-2222 | | ccc       | 333-3333 | | section 2 |          | | name      | number   | | ddd       | 444-4444 | | eee       | 555-5555 | +-----------+----------+ 

i have been trying make change end changing structure of report. when googled grouping gave me column level , row level grouping understand extent not figure out changing section related helpful.any links welcome grouping this. , not grouping in query, query straightforward select statement.

i'm assuming you're table looks in ssrs being grouped section:

if put 2 empty textboxes 'section' , second 1 expression points value of section group textbox think want. second picture below:

this expression in second textbox. reportitems names of text boxes, tables, lines, labels etc...that in report if find name of textbox section group row , reference in <<expr>> should work. , minimize actual section group column

here result got using test data etc. can see actual section groupby column small far left. there might way hide column completely.