Search the Community
Showing results for tags 'grand total'.
-
Good morning. I need to hide the row in a grid of the summay of the group, but show the row of grandTotal. How to do?
- 2 replies
-
- summary
- grand total
-
(and 1 more)
Tagged with:
-
Hello! My DBGrid contains columns with positive and negative values. I need to calculate 3 summary grand total values for every column - positive, negative and common summary (positive + negative). For this separate calculation I use Column.AuxValues[1], Column.AuxValues[2] and Column.AuxValues[3] in OnColumnSummary and OnColumnSummaryTotal events. OnColumnSummary: //positive if Column.Field.Value > 0 then Column.AuxValues[1] := Column.AuxValues[1] + Column.Field.Value; //negative if Column.Field.Value < 0 then Column.AuxValues[2] := Column.AuxValues[2] + Column.Field.Value; //total Column.AuxValues[3] := Column.AuxValues[1] + Column.AuxValues[2]; It works fine. In OnColumnSummaryTotal event I would like to display this grand total values in 3 lines for every column: Result := FormatFloat('##0.00', Column.AuxValues[1]) + #13#10 + FormatFloat('##0.00', Column.AuxValues[2]) + #13#10 + FormatFloat('##0.00', Column.AuxValues[3]); But it doesn't work, grand total row doesn't support text wrap and auto height. I can't place this values in 1 line because column will be too wide. Is there any way to solve this problem or I should use additional components to display multi line grand total? Thank you in advance for any advice!
- 8 replies
-
- dbgrid
- grand total
-
(and 1 more)
Tagged with:
-
Merhaba, Pivot gridde "grand total" kisimlarini nasil gizleyebilirim?