The GenerateReportForm does everything I need except for one thing. By default, it reports all the rows in a Grid and ignores filtering and grouping. There are lots of ways to get part way there (GetSortedDataRows, ugly cell-by-cell copying to a new Grid instance, etc.), but nothing I can see makes this easy or is do-able for large datasets. Any directions you can suggest would be greatly appreciated.
Imported from legacy forums. Posted by John (had 2225 views)
I solved my problem. I’ve posted for your knowledgebase.
For Each group As Xceed.Grid.Group In MyXceedGrid.Groups group.ReportStyle.KeepTogether = True Next group
For reporting only checked “Select” checkboxes that are unbound to the underlying grid:
For Each dataRow As Xceed.Grid.DataRow In MyXceedGrid.DataRows If True.Equals(dataRow.Cells(“Select”).Value) Then dataRow.ReportStyle.Visible = True Else dataRow.ReportStyle.Visible = False End If Next dataRow
For reporting filtered records, this is unnecessary because the user will use the checkboxes to select the records he/she wants. Filtering just gives him/her a faster way to view a subset of data, especially when the database is large.
Imported from legacy forums. Posted by John (had 3435 views)