2

I am using the Janus GridEx (Windows Forms) and would like to export the contents to Excel. We have used the export functionality that Janus has built in before, but especially with hierarchical grids the exported file looks unprofessional.

So now we have written our own exporting code and everything is working fine, except that total rows for child tables or groupings are not exported. The reason for this is that looping through GridEx.GetRows() and then recursively through parentRow.GetChildRows() does not pick up any of the total rows shown in the grid.

Does anyone know how to get to these total rows?

Veldmuis
  • 4,678
  • 4
  • 25
  • 25

2 Answers2

1

Use the ASP.NET built in data grid. It will solve your problem.

Olivier Jacot-Descombes
  • 104,806
  • 13
  • 138
  • 188
rajeshwar
  • 11
  • 1
0

When looping through .GetRows, you can check the JanusRow.RowType, if it equals Janus.Windows.GridEX.RowType.TotalRow, that row is one with total values in it.

*This is using v3.5 of the Janus Grid

Bedwell
  • 91
  • 6
  • This only works for total rows for tables - not total rows for groups. We are by now using Janus version 4. They might have changed something in the mean time or we might have missed this before. To get the total rows for groups you need to check for JanusRow.RowType = Janus.Windows.GridEX.RowType.GroupFooter – Veldmuis Jun 20 '12 at 10:14