showing group aggregates only

2 posts, 0 answers
  1. recotech
    recotech avatar
    18 posts
    Member since:
    Oct 2010

    Posted 13 Jul 2016 Link to this post

    hello, i am frequently wondering what is the best practice to list group aggregates only.

    1. grouping and aggregating in report, hiding the empty details section

    2. grouping and aggregating in data source with LINQ and just list them in the report


    a current practical example is listing the count of employees per department, floor and building.


    whatever solution i use, next time i have the same problem, i think the would be better...

  2. Katia
    Katia avatar
    760 posts

    Posted 14 Jul 2016 Link to this post

    Hello Sebastian,

    To show aggregated data for a group you can use a CrossTab item. The recommended way for organizing the data for the CrossTab is with CrossTab Wizard where you will be able to specify the data fields for row/column groups and the aggregate function(Count) for detail values.

    Groups can also be nested, for example there is a parent group Building which has a child group Floor which has a child group Department (How to: Add groups to Table item and Crosstab item).

    A working example demonstrating CrossTab functionality can be found in Telerik Reporting installation folder (<installation folder>\Telerik\Reporting <version>\Report Designer\Examples\ProductSales.trdp).

    Telerik by Progress
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top