RadGridview with 1-N table cardinality

[Yamina]

Hello Everyone,

I want to display on a gridview data from a table A with cardinality 1-N with several tables (B,C,D, E ..) . I want to display all table data (A,B,C,D, E ..) with a condition : to have exactly one line for each data from table A. the data from tables B, C, D … I want to display them as many columns, and iterate as long as I have data.

How can I achieve this? I thought of Pivotgrid but that does not answer exactly what I ask?

Please fined in attach what’s the grid should look like.

PS: i need also to export the Grid in an Excel file .

Thank you  .

[Anton Mironov]

Hi Yamina,

Thank you for the image and details provided.

In order to achieve the desired behavior, I would recommend using one of the following approaches:

• Custom merging of the cells in the Grid - https://www.telerik.com/forums/dynamically-add-remove-columns-and-cell-merge-of-kendo-ui-grid#4961719
• Setting hierarchy of Grids - https://demos.telerik.com/aspnet-mvc/grid/hierarchy

Give a try to the approaches above and let me know if further assistance is needed.

Kind Regards,
Anton Mironov
Progress Telerik