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

Crosstab Exec Group Total

3 Answers 181 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Michael
Top achievements
Rank 1
Michael asked on 13 Sep 2013, 03:32 PM
Hello Guys,
  I would like to access the group total value, to calculate percentages of the children elements of the group.
  In the screenshot, I would like to be able to retrieve the value 110 or 95, so I can calculate the percentages like 47/110, 24/110, 5/110, etc. for each of the rows.

  I have already tried accesing the column total using EXEC function, but it will give me the total (110 + 95), instead of the individual total.
  I tried also accesing to the specific cell textbox, but is "out of scope"

So, which would be the specific action to retrieve this value?

Thanks!

3 Answers, 1 is accepted

Sort by
0
Nasko
Telerik team
answered on 17 Sep 2013, 02:04 PM
Hello Michael,

In order to access the group total value you need to use the Exec function and pass to it one of the following arguments as a scope:
  1. Pass the name of the appropriate group as a scope (screenshot).
  2. Pass an empty string - "", which is the default scope. Then the report processor will find the nearest ancestor item defining a data scope.
Regards,
Nasko
Telerik

Have you tried the new visualization options in Telerik Reporting Q2 2013? You can get them from your account.

0
Michael
Top achievements
Rank 1
answered on 18 Sep 2013, 02:54 PM
Hi Nasko, thanks for your answer! 

Unfortunately, even though what you say works for group columns, it is not what I actually need.

When I pass an empty string to the scope, I get the whole column sum total. What I need is the total for the parent group, not for all the groups.

In the screenshot I attached in my first post, i need the values 110 or 95. Using empty string I will get value 205 which is the sum of both.

Hope this clarifies the issue.

Thanks!! 
0
Nasko
Telerik team
answered on 20 Sep 2013, 03:16 PM
Hello Michael,

Since we are not sure what is your exact group structure, please send us your report definition to review on our end.

Regards,
Nasko
Telerik

Have you tried the new visualization options in Telerik Reporting Q2 2013? You can get them from your account.

Tags
General Discussions
Asked by
Michael
Top achievements
Rank 1
Answers by
Nasko
Telerik team
Michael
Top achievements
Rank 1
Share this question
or