Hello,
we are using the Ultra win grid to show some values and such, like for instance the balance of a bank account. And when we export it theres always a grandtotal appearing at the bottom of the excel sheet with the totals of *all* columns. How can we disable that?
Hi,
Neither the grid nor the exporter automatically add any summaries. So if you are seeing summaries in the export that are not displayed in the grid, then your code must be adding those summaries into the layout somewhere. Check your code for calls to the Summaries.Add method, which is the typical method by which you would add a summary in code.
It's also possible to add summaries by loading a Layout into the grid. So if you don't see "Summaries.Add" anywhere, check for places where you might be calling grid.DisplayLayout.Load.
If none of that helps, then you could try handling the ExportStarted event of the UltraGridExcelExporter and explicitly calling Summaries.Clear on each band in e.Layout.Bands to remove all summaries from the export layout.
Well, the thing is i have no clue about any of this, much less the code behind it. I was practically thrown into this project, but anyways. I noticed these lines in the Initialize method of the grid
GridControl.DisplayLayout.Override.SummaryDisplayArea = SummaryDisplayAreas.Bottom | SummaryDisplayAreas.GroupByRowsFooter; GridControl.DisplayLayout.Override.GroupBySummaryDisplayStyle = GroupBySummaryDisplayStyle.SummaryCells; var summaryFooterCaptionVisible = DefaultableBoolean.False; if(ShowSummaryFooterCaption) summaryFooterCaptionVisible = DefaultableBoolean.True; GridControl.DisplayLayout.Override.SummaryFooterCaptionVisible = summaryFooterCaptionVisible;GridControl is of type UltraGrid.So far what i figured out is that all the "datasets" are in a "band". And the grid only has one band. It shows a summary for all values per dataset, which is correct, but then it shows a grand summary of all summaries of all datasets at the very bottom, which isnt wanted.The only things ive managed so far is to not show ANY summaries whatsoever or hide the band, and thus everything. I literally get a blank page then