Simple ? Q re Forcing Display of Summary in Group By thru Designer

385

lt_Purell posted over 15 years ago

I am currently using code(below) to force the addition of summaries to a wingrid. However, I have a situation where I would simply like to force the display of the summary, as well format for the correct data type, through the designer. Specifically, I want the data to come up to come up in outlook group by format, with the groups closed, but the summary totals showing. Generally speaking I want to display customers grouped by sales representative code(each rep has many customers), and display the total(summary) sales for this and last year(in separate columns) of the group by(to show how much sales the sales representative) has made. The goal being to be able to quickly look at a large number of reps and see how much they have sold, and then expand the data to see that reps actual customers. I have been through the docs, and the properties, and I just can’t seem to get the settings right. Any help would be appreciated.

Dim i As Integer

Dim iBand As Integer

For i = 1 To Me.UGMain.DisplayLayout.Bands.Count

iBand = i - 1

For Each t In Me.UGMain.DisplayLayout.Bands(iBand).Columns

'Debug.Print(t.Header.Caption & " " & t.DataType.ToString)

If t.DataType.ToString <> "System.String" And t.DataType.ToString <> "System.DateTime" Then

e.Layout.Bands(iBand).Summaries.Add(t.Header.Caption, SummaryType.Sum, t, SummaryPosition.UseSummaryPositionColumn)

e.Layout.Bands(iBand).Summaries.Item(t.Header.Caption).DisplayFormat = "{0:$#,##0}"

End If

Parents

975

Geoff posted over 15 years ago

Sorry I don't have time for a detailed answer, but as newbie I've found the Feature Picker to be helpful as a quick start for many grid behaviors. It's in the Designer, under "Basic Settings".

Bill
Cancel
Reply

Cancel

Reply

469350

Offline Mike Saltzman posted over 15 years ago in reply to Geoff

Hi,
Which part of this is giving you trouble?
What kinds of data source are you using for your grid? If the data source and it's structure are available at design-time, then you should be able to modify the groups and summaries in the grid in the designer by just setting properties or even dragging and dropping columns in the form designer.
If your data source is not available at design-time, then it will be much more complicated and I would recommend using the InitializeLayout event to apply the settings in code.
Cancel
Reply

Cancel

Children

No Data