Page totals - using RunningValue code snippet required

[S Konduru]

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

[S Konduru]

Hi Telerik support Team, 

Please help me with some example.

Regards,
Suresh

[Peter]

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

[S Konduru]

Thanks Peter. Much appreciated.

[Bob]

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))

[chris_cf]

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]".

[Peter]

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