How can i reference a value from table in group header

2 posts, 0 answers
  1. Naureen
    Naureen avatar
    17 posts
    Member since:
    Oct 2016

    Posted 24 Nov 2016 Link to this post

    In my report I have a table that i calculating sum of values in a column. I want to be able to use the sum value in group footer as well. How can i reference the value in group footer? What is the way to store the value in variable for it to be able to be used at any other place in report. 
  2. Katia
    Admin
    Katia avatar
    693 posts

    Posted 25 Nov 2016 Link to this post

    Hi Naureen,

    Expressions are evaluated against the data scopes.

    To be able to use the data fields that are defined in the different data scope you can use data functions. You can only specify the current scope or a containing scope, you cannot specify a scope that is lower or at the same level in containment order than the current scope.

    In your scenario, the data is bound to report's inner data item(table) and it will not be possible to reach the table's data scope inside the GroupFooter section as it will not be in the containing scope.
    Check if binding the data source to report instead of the Table item can be applied in your scenario.
    Another approach can be to place another data item inside the GroupFooter section and bind it to the same data source as table uses.


    Standalone Designer does not support saving the values of one report item and using them for another report item, it can be done only programmatically.


    Regards,
    Katia
    Telerik by Progress
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top