Hello. I have a RadGridView with a large collection of items (4000 columns, up to 400 rows), which are grouped together (4 columns in each group). Currently, we're generating the columns and groups in the codebehind, but it takes a long time to generate the table since we're creating every column and group object, even if they're not currently shown.
We end up with a table that looks similar to the (completely fake) attached image - 4 columns of statistics for each item in the header.
I'd like to try autogenerating the columns and groups, using virtualization so we don't have to create the view objects for every column and group unless they're needed. However, I don't know how to autogenerate the groups. Is there a way to do so in the xaml? Or, is the solution to autogenerate the columns, but add the groups programatically as the columns are generated?
I haven't attached any dummy data, since I expect the data has to be organized in a specific manner to get this to work.
Thanks in advance for any help you can provide.