Place a Total Field in the Detail Band

Sometimes you might prefer to place a Total Field into the Detail Band instead of a Group Footer.

• Move the Total field from the GroupFooter band to the DetailBand.

• Set the Total field to Visible = No.

• Select the Reports scripting language.

• Select the Total field and enter the following code on BeforePrint.

Private Sub OnBeforePrint(ByVal sender As Object, ByVal e As System.Drawing.Printing.PrintEventArgs)
If sender.Report.CurrentRowIndex=sender.Report.RowCount-1 orelse GetCurrentColumnValue(“Invoice”) <> “” & sender.Report.GetNextColumnValue(“Invoice”) Then
txtTotal.visible=True
Else
txtTotal.visible=False
End If
End Sub

Note! “txtTotal” is the Total Field.

Final Result:

Now each Group Total is placed beside the last detail instead in the Group Footer.