Page totals - using RunningValue code snippet required

7 posts, 0 answers
  1. S Konduru
    S Konduru avatar
    3 posts
    Member since:
    Apr 2010

    Posted 30 Jul 2010 Link to this post

    Hi, 

    I am new to Telerik Reporting and I am wondering how can I achieve the page break totals. I searched the forum but could not find any code snippet on how to use RunningValue function. When I converted the existing crystal report to Telerik report all the page running totals were not converted. Could you please guide me with some information.

    Regards,
    Suresh
  2. S Konduru
    S Konduru avatar
    3 posts
    Member since:
    Apr 2010

    Posted 03 Aug 2010 Link to this post

    Hi Telerik support Team, 

    Please help me with some example.

    Regards,
    Suresh
  3. DevCraft banner
  4. Peter
    Admin
    Peter avatar
    1611 posts

    Posted 04 Aug 2010 Link to this post

    Hi S Konduru,

    RunningValue(scope, aggregateFunction)  is a Function that must be used in an Expression. Check out the following example. In that case my scope is a table item - table1 and I am aggregating a sales field.

    = RunningValue("table1",Sum(Fields.Sales))

    If you inspect the InitializeComponent() method for the code it was generated you will see the following line:
    this.textBox10.Value = "= RunningValue(\"table1\",Sum(Fields.Sales))";

    As noted in Converting reports from other reporting solutions help article - the converters are just a helper utility we did out of good will to save some time. They do not guarantee a one-to-one complete conversion and are provided as is.  The expressions are not converted due to differences in the model between the reporting tools.

    Regards,
    Peter
    the Telerik team
    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 Public Issue Tracking system and vote to affect the priority of the items
  5. S Konduru
    S Konduru avatar
    3 posts
    Member since:
    Apr 2010

    Posted 05 Aug 2010 Link to this post

    Thanks Peter. Much appreciated.
  6. Bob
    Bob avatar
    21 posts
    Member since:
    Mar 2008

    Posted 31 Oct 2010 Link to this post

    Peter,

    The function RunningValue might be my solution but I can not seen to find the right scope.  I tried the group name, group textbox name, group header name and got syntax errors.

    = RunningValue("GroupFooterSection2", Sum(Fields.project_Budget))

    How do I identify a scope?

    Regards,

    Bob

    P.S  I discovered the syntax is = RunningValue(Fields.DOE, Sum(Fields.project_Budget))

    I am still looking for a way of Sum(DISTINCT Fields.project_Budget))
  7. chris_cf
    chris_cf avatar
    53 posts
    Member since:
    Jul 2007

    Posted 13 Oct 2011 Link to this post

    How to I specify the scope as the report?

    I am binding a datasource to the report programmatically.

    I am not using a table to display the detail data, only textboxes which display field values using "[=Fields.FieldName]".
  8. Peter
    Admin
    Peter avatar
    1611 posts

    Posted 18 Oct 2011 Link to this post

    Hi Chris_Cf,

    The scope is specified with the report item's name. Thus in case of the report you can use the report's name. You may find useful the Functions help article.

    Regards,
    Peter
    the Telerik team

    Q2’11 SP1 of Telerik Reporting is available for download (see what's new). Get it today.

Back to Top
DevCraft banner