Hi!
I have a problem on group by expression.
My expression is:
Dim expression As GridGroupByExpression = New GridGroupByExpression
Dim gridGroupByField As GridGroupByField = New GridGroupByField
'Add select fields (before the "Group By" clause)
gridGroupByField = New GridGroupByField
gridGroupByField.FieldName = "Modelo"
gridGroupByField.HeaderText = "Modelo"
gridGroupByField.HeaderValueSeparator = ": "
gridGroupByField.FormatString = "<strong>{0}</strong>"
expression.SelectFields.Add(gridGroupByField)
gridGroupByField = New GridGroupByField
gridGroupByField.FieldName = "TotalEnc"
gridGroupByField.HeaderText = " Quantidade"
gridGroupByField.HeaderValueSeparator = ": "
gridGroupByField.FormatString = "<strong>{0}</strong>"
gridGroupByField.Aggregate = GridAggregateFunction.Sum
expression.SelectFields.Add(gridGroupByField)
gridGroupByField = New GridGroupByField
gridGroupByField.FieldName = "ValorEnc"
gridGroupByField.HeaderText = " Total"
gridGroupByField.HeaderValueSeparator = ": "
gridGroupByField.FormatString = "<strong>{0:C}</strong>"
gridGroupByField.Aggregate = GridAggregateFunction.Sum
expression.SelectFields.Add(gridGroupByField)
'Add a field for group-by (after the "Group By" clause)
gridGroupByField = New GridGroupByField
gridGroupByField.FieldName = "Modelo"
gridGroupByField.FieldAlias = "ola"
expression.GroupByFields.Add(gridGroupByField)
And in the result it shows:
Modelo: 5373Modelo Quantidade: 0Modelo Total: 0,00 €
How can i change the word Modelo by ; ???
Thanks!
I have a problem on group by expression.
My expression is:
Dim expression As GridGroupByExpression = New GridGroupByExpression
Dim gridGroupByField As GridGroupByField = New GridGroupByField
'Add select fields (before the "Group By" clause)
gridGroupByField = New GridGroupByField
gridGroupByField.FieldName = "Modelo"
gridGroupByField.HeaderText = "Modelo"
gridGroupByField.HeaderValueSeparator = ": "
gridGroupByField.FormatString = "<strong>{0}</strong>"
expression.SelectFields.Add(gridGroupByField)
gridGroupByField = New GridGroupByField
gridGroupByField.FieldName = "TotalEnc"
gridGroupByField.HeaderText = " Quantidade"
gridGroupByField.HeaderValueSeparator = ": "
gridGroupByField.FormatString = "<strong>{0}</strong>"
gridGroupByField.Aggregate = GridAggregateFunction.Sum
expression.SelectFields.Add(gridGroupByField)
gridGroupByField = New GridGroupByField
gridGroupByField.FieldName = "ValorEnc"
gridGroupByField.HeaderText = " Total"
gridGroupByField.HeaderValueSeparator = ": "
gridGroupByField.FormatString = "<strong>{0:C}</strong>"
gridGroupByField.Aggregate = GridAggregateFunction.Sum
expression.SelectFields.Add(gridGroupByField)
'Add a field for group-by (after the "Group By" clause)
gridGroupByField = New GridGroupByField
gridGroupByField.FieldName = "Modelo"
gridGroupByField.FieldAlias = "ola"
expression.GroupByFields.Add(gridGroupByField)
And in the result it shows:
Modelo: 5373Modelo Quantidade: 0Modelo Total: 0,00 €
How can i change the word Modelo by ; ???
Thanks!