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

4 posts, 0 answers
  1. Derek
    Derek avatar
    118 posts
    Member since:
    Oct 2008

    Posted 07 Aug 2014 Link to this post

    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?
  2. Nasko
    Admin
    Nasko avatar
    909 posts

    Posted 12 Aug 2014 Link to this post

    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
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  3. DevCraft banner
  4. Derek
    Derek avatar
    118 posts
    Member since:
    Oct 2008

    Posted 13 Aug 2014 in reply to Nasko Link to this post

    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?
  5. Nasko
    Admin
    Nasko avatar
    909 posts

    Posted 18 Aug 2014 Link to this post

    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
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
Back to Top