I have table which has 5 columns(col1,col2,col3,col4,col5) very simple and some data .

I would like to create a tabular  report  datasets on the report like shown below with grouping on col1

like

col1  some static text and dynamic text

------------------------

col1 col2 col3 col4

data data data data

------------------------

col1 some static & dynamic text

------------------------

col1 col2 col3 col4

data data data data

------------------------

Note I need to keep all the tables on the same page and when exported in excel they should come on same page sheet



Hi MLTC,

According to your description, you want to create a report to display each group instances separately, right?

In Reporting Services, a list control can be used for displaying grouped data with multiple views. So in your scenario, you could embed textbox or tablix controls in a list control. Please refer to screenshots below:

Reference:
Lists (Report Builder and SSRS)

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu