Report Viewer or Gridview/Datalist/Repeater

I want to display data in format

Store Name
Department1
User1 2 3 5 6
User2 2 3 5 6
User3 2 3 5 6
User4 2 3 5 6

Department2
User1 2 3 5 6
User2 2 3 5 6
Us开发者_开发技巧er3 2 3 5 6
User4 2 3 5 6

Store Name1
Department1
User1 2 3 5 6
User2 2 3 5 6
User3 2 3 5 6
User4 2 3 5 6

Department2
User1 2 3 5 6
User2 2 3 5 6
User3 2 3 5 6
User4 2 3 5 6

WHich control is best way to display data in above format. With gridview i have to get each department for given store merge it and show data. Note: My columns are dynamic

How about nested Repeater controls?

You can use nested DataList control to get this type of output. For that you have to take two datalist Fist one will hold your master data and second one will repeat your data.You have to trap DataList.ItemDataBound Event of first datalist and then find value of id and bind another datalist to fill it.

You could create user control, which displays

Department2
User1 2 3 5 6
User2 2 3 5 6
User3 2 3 5 6
User4 2 3 5 6

Then create a list of controls and add them to a panel or some container, which has verticla scroll bar.