User (Old forums)MemberMay 15, 2006 at 5:59 pmPost count: 23064
Dim unitCell As SummaryCell = New SummaryCell
unitCell.StatFieldName = “BITS”
unitCell.StatFunction = StatFunction.Sum
unitCell.TitleFormat = “THIS IS MY %SUM:BITS%”
What am i miss here?
Imported from legacy forums. Posted by Brian (had 5161 views)User (Old forums)MemberMay 16, 2006 at 11:27 amPost count: 23064
What is not functioning? If it is the text “THIS IS MY ” that is not displayed, and you need only one column to be displayed, then do it on the SummaryRow instead, and reset the SummaryCell properties. If it is the sum that is not display, make sure that the name of the column is the right one (it is case sensitive). Have a look at the following post :
Imported from legacy forums. Posted by André (had 479 views)User (Old forums)MemberMay 16, 2006 at 1:30 pmPost count: 23064
I had the summaryrow working… but now I want to try and summarize several cells. that part that is not working is the summing for the cell Bits.
Yes, I know now that is case sensivtive, that got me on the row summary. Just for some reason, I am having a hard time trying to figure out exactly what needs to be set to have totals, or stats, of several different columns in my groups
btw, I am looking of group base stats…
Imported from legacy forums. Posted by Brian (had 496 views)User (Old forums)MemberMay 16, 2006 at 4:37 pmPost count: 23064
First, the TitleFormat property must NOT be set to “THIS IS MY %SUM:BITS%, but only to “THIS IS MY “, since there are two properties, StatFieldName and StatFunction, that serve this purpose. You need to do it only on the SummaryRow.TextFormat because these properties are not on the SummaryRow.
Second, the TitlePosition property sets where the “THIS IS MY ” title is displayed. The TitleFormat is always displayed in the SummaryCell next to the one running the statistical function, for the function uses the whole cell to display its result. If you use the first SummaryCell, you need to set the TitlePosition to right, else the title will not be displayed. If you have set the TextFormat on the SummaryRow, then you cannot use the first or the second SummaryCell (or any cell that the SummaryRow writes to for that matter), for the statistical function result will be displayed over the TextFormat of the SummaryRow. In the second cell, if you set the the TitlePosition to right, then it can work if the SummaryRow.TextFormat is limited to the first cell.
This is a long description, a bit hard to follow, but once you understand how it functions, then you will have no problem using this functionality.
Imported from legacy forums. Posted by André (had 1369 views)User (Old forums)MemberMay 16, 2006 at 9:53 pmPost count: 23064
Dim ix As Integer
For ix = 5 To 10
mysummarycell = CType(mysummaryrow.Cells(ix), SummaryCell)
.StatFunction = StatFunction.Sum
‘.TitleFormat = “TEST”
Imported from legacy forums. Posted by Brian (had 372 views)User (Old forums)MemberMay 16, 2006 at 9:54 pmPost count: 23064
ok.. the display value that goes into the cell.. say should look like 5100.90 but looks like 5100.9012421312
how do i format it to 2 decmials?
Imported from legacy forums. Posted by Brian (had 374 views)User (Old forums)MemberMay 24, 2006 at 4:18 pmPost count: 23064
You can use the FormatSpecifier property on the SummaryCell, and to something like this :
or use the predefined constants, like :
Currency, Fixed-point, Decimal, etc..
Imported from legacy forums. Posted by André (had 6605 views)
- You must be logged in to reply to this topic.