Hi Plamena,

I am working on it and I will solve this issue myself.

Thanks,
Shaolin

Hi Plamena,

Thanks so much for your reply!

Best Regards,
Shaolin

Hi Plamena,

Thanks so much for your Sample app.

Is there a way to combine column header with its empty group header for those individual columns (Column 1, 2 …) that are not in any group?

Why is this approach called something related to ColScrollRegion? I knew this approach a while ago but did not know it has any thing to do with ColScrollRegion. Sorry, it is just my curiosity 🙂

Your help is greatly appreciated!

Best Regards,
Shaolin

Hi Plamena,

Thanks so much for your quick reply!

One of the requirements I mentioned is Fixed columns and groups, which is not supported with the group layout. The RowLayoutStyle is set to None. Can you send me a sample application please?

Your help is greatly appreciated!

Best Regards,
Shaolin

Hi Milko,

It worked and I appreciate your help.

Best regards,
Shaolin

Hi Milko,

Thanks for your reply!

All child bands are added at run time and a child band is added when it is needed. We use a virtual UltraDataSource and we use its event InitializeRowsCollection and CellDataRequested. Each band has only one child band with the same columns. The following is the code snippet we have:

UltraDataBand childDataBand = band.ChildBands.Add(name);
foreach (IField field in fields)
     childDataBand.Columns.Add(field.Name, field.Type);

Your help is greatly appreciated!

Best Regards,
Shaolin

Hi John,

Thanks for your sample code, which helped me to understand exporting to Excel better.

Best Regards,
Shaolin