Hi Fasiha,

I'm not sure I understand your question. The code you have here is always setting SkipRow and SkipDescendants to false, so this will essentially do nothing.

Hi,

I'm used Initialize Row event to export child bands in excel. I'm getting the output. But my problem is that it dosen't exporting Column header of child bands. Am i missing any thing?

//To export child band in excel

private static void excelExporter_InitializeRow(object sender, ExcelExportInitializeRowEventArgs e)
        {
            UltraGrid grid = e.Row.Band.Layout.Grid as UltraGrid;
            UltraGridRow realGridRow = grid.GetRowFromPrintRow(e.Row);
            e.Row.Band.Header.Activated = true;
             if (realGridRow.Band.Index == 1 && realGridRow.Selected == false)
            {
                e.SkipRow = false;
                e.SkipDescendants = false;
            }
            else if (realGridRow.Band.Index == 2 && realGridRow.Selected == false)
            {
                e.SkipRow = false;
                e.SkipDescendants = false;
            }
        }

Thanks & Regards,

Fasiha

 Could you post a sample which reproduces the unwanted behavior?

-Justin

Hi 

I am Dhanraj.

I implement the above code successfully selected rows exported. 

but didn't show the header name of particular child.

Pls help me.. 

 After playing with this a bit more, I noticed that I was getting extra group by rows in my export.  I solved this by using the following code.  It seems to cover all of the scenarios that my application runs into.  Initially I was worried about performance issues from iterating child rows, however; as long as foundSelectedRows == false is the common scenario (as it is in my app), the performance hit shouldn't be too large.  Thanks for the help.

      private void ultraGridExcelExporter1_InitializeRow(object sender, ExcelExportInitializeRowEventArgs e) {
         bool foundSelectedRows = false;
         UltraGrid grid = e.Row.Band.Layout.Grid as UltraGrid;
         UltraGridRow realGridRow = grid.GetRowFromPrintRow(e.Row);

         if (realGridRow.IsGroupByRow) {
            foreach (UltraGridChildBand band in realGridRow.ChildBands) {
               foreach(UltraGridRow row in band.Rows) {
                  if (row.Selected) {
                     foundSelectedRows = true;
                     break;
                  }
               }
            }
            if (foundSelectedRows == false) {
               e.SkipRow = true;
               e.SkipDescendants = true;
            }
         } else if (realGridRow.Band.Index == 0 && realGridRow.Selected == false) {
            e.SkipRow = true;
            e.SkipDescendants = true;
         }
      }