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

Sum of calculated fields in detail section into a parent group

3 Answers 478 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Kevin
Top achievements
Rank 1
Kevin asked on 03 Apr 2012, 10:38 AM
Hi everybody,

I have problem to make a report that my boss ask me to do.

It comprises 4 groups, the detail section, and the groups footers.

Into the detail section, there are a lot of textboxes whose values are calculated with expressions like this :

IIf(BooleanReturnedByAUserFunction(string field), aFieldOfDataSource, "+0")

The group above of this detail section comprises the same organisation of textboxes that the detail section.

Into these texboxes, I have to calculate the sum of the calculated fields of the corresponding textbox in the detail section.

It is possible with Telerik Reporting ?
If yes, i would be very grateful if you could help me.

Thanks and nice day.


3 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 03 Apr 2012, 02:20 PM
Hello Kevin,

You can use the Scope related functions for such purpose. For example using the Exec(scope, expression) with scope - the name of the group and expression Sum(your calculated field result/expression) should return the expected results.

Kind regards,
Steve
the Telerik team
NEW in Q1'12: Telerik Report Designer (Beta) for ad-hoc report creation. Download as part of Telerik Reporting Q1 2012. For questions and feedback, use the new Telerik Report Designer Forum.
0
Ileana
Top achievements
Rank 1
answered on 03 Apr 2013, 07:57 PM
Hello! I am using a calculated field in a report, when I preview it on the designer works perfectly , showing me the results, but when I run my application in my SQL sentence with the query for the report it has an error for those calculated fields, what could it be? do I have to include their names in the select sentence?
0
Hadib Ahmabi
Top achievements
Rank 1
answered on 08 Apr 2013, 08:44 AM
The calculated fields are just for the report.
What do you mean by "when I run my application in my SQL sentence with the query for the report" ?
What and where are you trying to run?

Tags
General Discussions
Asked by
Kevin
Top achievements
Rank 1
Answers by
Steve
Telerik team
Ileana
Top achievements
Rank 1
Hadib Ahmabi
Top achievements
Rank 1
Share this question
or