How to hide the summary (sigma) button? | Infragistics Forums

State See Verified Answer
Replies 15 replies
Answers 1 answer
Subscribers 7 subscribers
Views 3721009 views
Users 0 members are here

195

How to hide the summary (sigma) button?

Larry posted over 15 years ago

Hi,

I have an UltraGrid with several columns and on certain columns I have enabled Row Summaries.

I would like to remove the button that allows to user to select which summary to display while keeping the summary down at the bottom of my grid.

I have attached a picture of a column that does not display the summary button.

Do you know how to do this?

45049

[Infragistics] Vince McDonald posted over 15 years ago in reply to Larry

Larry,

We'll need more information to determine what is happening here. The result you've described is not the result I expected. Based on the information you quoted, I'd have expected the "sigma" symbol to not appear.

Can you reproduce this in a sample that we can run and debug? If so, I recommend that you submit a support request, so that a Developer Support Engineer can investigate this more in-depth and work with you to find a resolution. Make sure you provide a link to this forum thread, so that the Developer Support Engineer knows more about the background of this issue.

You can alternately attach a sample here (using the Options tab). I will then pass this information to have a support case created for you. This will take a little longer than if you submit the support request directly.
Cancel
Reply

Cancel
195

Larry posted over 15 years ago in reply to [Infragistics] Vince McDonald

Yes, I am qouting code from the Windows Forms Designer.

I performed a search in the code file for AllowRowSummaries and did not find any matches. In addition, the code does not handle the InitializeLayout event for the grid.

The only other calls on the grid are to set and clear ColumnFilters and PerformAutoResize on a column.

Do you have any more ideas?

Thanks

Larry
Cancel
Reply

Cancel
45049

[Infragistics] Vince McDonald posted over 15 years ago in reply to Larry

This code looks like it was quoted from the Windows Forms Designer Generated Code section of your form's Designer file.

Are you setting an AllowRowSummaries property somewhere else in your code, such as in the grid's InitializeLayout event? That's the only reason that I can think why a setting applied at design-time wouldn't be functioning at run-time.
Cancel
Reply

Cancel
195

Larry posted over 15 years ago in reply to [Infragistics] Vince McDonald

I tried what you suggested but it appeared to have no effect.

Here is a snippet of my code:

Dim UltraGridBand1 As Infragistics.Win.UltraWinGrid.UltraGridBand = New Infragistics.Win.UltraWinGrid.UltraGridBand("UltraGridBand1", -1) Dim UltraGridColumn1 As Infragistics.Win.UltraWinGrid.UltraGridColumn = New Infragistics.Win.UltraWinGrid.UltraGridColumn("Edit") Dim UltraGridColumn2 As Infragistics.Win.UltraWinGrid.UltraGridColumn = New Infragistics.Win.UltraWinGrid.UltraGridColumn("Name") Dim UltraGridColumn3 As Infragistics.Win.UltraWinGrid.UltraGridColumn = New Infragistics.Win.UltraWinGrid.UltraGridColumn("Planned") Dim UltraGridColumn4 As Infragistics.Win.UltraWinGrid.UltraGridColumn = New Infragistics.Win.UltraWinGrid.UltraGridColumn("PercentChange") Dim UltraGridColumn5 As Infragistics.Win.UltraWinGrid.UltraGridColumn = New Infragistics.Win.UltraWinGrid.UltraGridColumn("Projected") Dim UltraGrid1 = New Infragistics.Win.UltraWinGrid.UltraGrid
Dim Appearance1 As Infragistics.Win.Appearance = New Infragistics.Win.Appearance Dim Appearance2 As Infragistics.Win.Appearance = New Infragistics.Win.Appearance Dim Appearance3 As Infragistics.Win.Appearance = New Infragistics.Win.Appearance Dim Appearance4 As Infragistics.Win.Appearance = New Infragistics.Win.Appearance Dim SummarySettings1 As Infragistics.Win.UltraWinGrid.SummarySettings = New Infragistics.Win.UltraWinGrid.SummarySettings("SalesSummary", Infragistics.Win.UltraWinGrid.SummaryType.Sum, Nothing, "Planned", 1, True, "DataSource1", 0, Infragistics.Win.UltraWinGrid.SummaryPosition.UseSummaryPositionColumn, "Planned", 1, True) Dim SummarySettings2 As Infragistics.Win.UltraWinGrid.SummarySettings = New Infragistics.Win.UltraWinGrid.SummarySettings("PercentChangeSummary", Infragistics.Win.UltraWinGrid.SummaryType.Formula, Nothing, "PercentChange", 2, True, "DataSource1", 0, Infragistics.Win.UltraWinGrid.SummaryPosition.UseSummaryPositionColumn, "PercentChange", 2, True) Dim SummarySettings3 As Infragistics.Win.UltraWinGrid.SummarySettings = New Infragistics.Win.UltraWinGrid.SummarySettings("ProjectedSummary", Infragistics.Win.UltraWinGrid.SummaryType.Sum, Nothing, "ProjectedSales", 3, True, "DataSource1", 0, Infragistics.Win.UltraWinGrid.SummaryPosition.UseSummaryPositionColumn, "Projected", 3, True) UltraGridColumn1.CellButtonAppearance = Appearance1 UltraGridColumn1.Header.Caption = "" UltraGridColumn1.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Button UltraGridColumn1.Width = 20 UltraGridColumn2.Width = 170 UltraGridColumn3.AllowRowSummaries = Infragistics.Win.UltraWinGrid.AllowRowSummaries.[True] UltraGridColumn4.AllowRowSummaries = Infragistics.Win.UltraWinGrid.AllowRowSummaries.[True] UltraGridColumn4.Header.Caption = "% Change" UltraGridColumn5.AllowRowSummaries = Infragistics.Win.UltraWinGrid.AllowRowSummaries.[True] Appearance1.Image = Global.My.Resources.Resources.Lookup_Edit Appearance1.ImageHAlign = Infragistics.Win.HAlign.Center UltraGridBand1.Columns.AddRange(New Object() {UltraGridColumn1, UltraGridColumn2, UltraGridColumn3, UltraGridColumn4, UltraGridColumn5}) UltraGridBand1.Override.AllowRowSummaries = Infragistics.Win.UltraWinGrid.AllowRowSummaries.[False] SummarySettings1.DisplayFormat = "{0:$0}" SummarySettings1.GroupBySummaryValueAppearance = Appearance2 SummarySettings1.SummaryDisplayArea = Infragistics.Win.UltraWinGrid.SummaryDisplayAreas.Bottom SummarySettings2.DisplayFormat = "{0:0%}" SummarySettings2.GroupBySummaryValueAppearance = Appearance3 SummarySettings2.SummaryDisplayArea = Infragistics.Win.UltraWinGrid.SummaryDisplayAreas.Bottom SummarySettings3.DisplayFormat = "{0:$0}" SummarySettings3.GroupBySummaryValueAppearance = Appearance4 SummarySettings3.SummaryDisplayArea = Infragistics.Win.UltraWinGrid.SummaryDisplayAreas.Bottom UltraGridBand1.Summaries.AddRange(New Infragistics.Win.UltraWinGrid.SummarySettings() {SummarySettings1, SummarySettings2, SummarySettings3}) UltraGridBand1.SummaryFooterCaption = "Total" UltraGrid1.DisplayLayout.BandsSerializer.Add(UltraGridBand1) UltraGrid1.DisplayLayout.Override.AllowRowSummaries = Infragistics.Win.UltraWinGrid.AllowRowSummaries.[False] UltraGrid1.Location = New System.Drawing.Point(0, 0) UltraGrid1.Name = "UltraGrid1" UltraGrid1.Size = New System.Drawing.Size(942, 377) Me.Controls.Add(UltraGrid1)

I would like to keep the column summaries and hide the sigma button. I have attached another screen shot showing what the ultragrid looks like at run time at the top and what I would like to appear at the bottom.

Thanks in advance

Larry
Cancel
Reply

Cancel
45049

Suggested Answer
[Infragistics] Vince McDonald posted over 15 years ago

From the Override object, set the AllowRowSummaries property to False (Infragistics.Win.UltraWinGrid.AllowRowSummaries.False).

You can find an Override object connected to the DisplayLayout (to apply to all bands in the grid) and connected to each individual band (to apply to that individual band).
Cancel
Reply

Reject Answer

Cancel