This is a migrated thread and some comments may be shown as answers.

Group Footer - Change Value Dependant on Detail Values

5 Answers 138 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
TPerry
Top achievements
Rank 1
TPerry asked on 15 May 2009, 03:24 PM
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

Sort by
0
Steve
Telerik team
answered on 18 May 2009, 01:54 PM
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.
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
Steve
Telerik team
answered on 19 May 2009, 07:16 AM
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.
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
Steve
Telerik team
answered on 21 May 2009, 09:37 AM
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.:

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.
Tags
General Discussions
Asked by
TPerry
Top achievements
Rank 1
Answers by
Steve
Telerik team
TPerry
Top achievements
Rank 1
Share this question
or