EXEC function; can I show only current row and column group?

[Derek]

We are working on a crosstab report where there is a row group (Category) and two column groups (Location and Gender),  and we are showing total hours as the value. What we'd like to do is to show the hours as a percentage of the total for that Category and Location. The attached screenshot shows what we want, and also what the report designer gives us.

Basically if we have Category 1 and Location 1, we'd like to show the percentage of females for that category and location only. We are using an expression like

= Sum(Fields.TotalHours)/ exec("Gender1",Sum(Fields.TotalHours))

However this EXEC statement returns the total for the whole Gender group. We've tried the other groups, with similar results.

Is there a way to sum only across the current range of values?

[Nasko]

Hello Derek,

The described functionality can be achieved and the needed data can be displayed in the crosstab by changing the crosstab item layout. Please check the attached report for a demonstration of the solution.

Regards,
Nasko
Telerik

 

 

[Derek]

Just so I understand; you suggest moving the parent column group over to a row group?

Is there no way to do this with multiple column and row groups, as per my original post?

[Nasko]

Hello Derek,

Yes, I suggest using a row group instead of a column group for the location. This will allow you to use a single scope in the Exec function and show the desired data.
With multiple column and row groups there is no way to specify the scope that you need in order to show the same data.

Regards,
Nasko
Telerik

 

 

[Guido]

"With multiple column and row groups there is no way to specify the scope that you need in order to show the same data."  Is there a way to get this working now or is it still not possible?

[Todor]

You may try with the data function Exec(scopeByColumns, scopeByRows, expression). It lets you specify a more detailed scope.