I have a field, called BudgetedCost. That field either contains a numeric value or ****, this is displaying fine in the Detail Section. Great. Now, in the Group Footer, I want to either display a Sum of BudgetedCost (which I can do) or if any of the detail rows contain ****, I need to display ****. I can't figure out how to do this. Any help? Thanks in advance!
5 Answers, 1 is accepted
0
Hi TPerry,
You can hook up the ItemDataBound event of the textbox item in the groupfooter and depending on the value of the field, display either sum of the field or custom text.
Kind regards,
Steve
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
You can hook up the ItemDataBound event of the textbox item in the groupfooter and depending on the value of the field, display either sum of the field or custom text.
Kind regards,
Steve
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0

TPerry
Top achievements
Rank 1
answered on 18 May 2009, 05:02 PM
Hi - that's what I thought, but in thItemDataBound event, if I look at the value, it says
=Sum(Fields.BudgetedCost) and not the actual value that it's about to return.
0
Hello TPerry,
That cannot be right as in the ItemDataBound the evaluated expression should be present for the Value. Are you sure you have not wired up ItemDataBinding by mistake?
Sincerely yours,
Steve
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
That cannot be right as in the ItemDataBound the evaluated expression should be present for the Value. Are you sure you have not wired up ItemDataBinding by mistake?
Sincerely yours,
Steve
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0

TPerry
Top achievements
Rank 1
answered on 20 May 2009, 05:20 PM
That's what I thought too! Here's my event...
Private Sub TextBox26_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox26.ItemDataBound
Dim test As String = Me.TextBox26.Value
End Sub
And test is returned as (copied from the Locals window):
test "=Sum(Fields.BudgetedCost)" String
And my field exists in the Group Footer and the expression looks like this:
=Sum(Fields.BudgetedCost)
0
Hi TPerry,
That is because you're using the definition item value i.e. the hardcoded value in the report designer, when you should be using the processing value instead i.e.:
More info on processing vs. definition is available in this help article.
Hope this helps.
Sincerely yours,
Steve
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
That is because you're using the definition item value i.e. the hardcoded value in the report designer, when you should be using the processing value instead i.e.:
Private Sub textBox26_ItemDataBound(sender As Object, e As EventArgs) |
Dim txt As Telerik.Reporting.Processing.TextBox = DirectCast(sender, Telerik.Reporting.Processing.TextBox) |
Dim processing As String = txt.Value.ToString() 'contains expected valu |
Dim definition As String = Me.textBox26.Value 'wrong: always contains the default value |
End Sub |
More info on processing vs. definition is available in this help article.
Hope this helps.
Sincerely yours,
Steve
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.