How to show summary info from rows

7 posts, 0 answers
  1. P
    P avatar
    12 posts
    Member since:
    Jul 2019

    Posted 29 Jan Link to this post

    Hello, 

    Could you advice on how to show summary info from row values?

    The data source data looks like this - see RawData.png attached. 

    I need to show a table which looks like this - see ResultData.png attached. 

     

    Thanks

  2. Katia
    Admin
    Katia avatar
    714 posts

    Posted 03 Feb Link to this post

    Hello,

    The described scenario can be achieved using the CrossTab item. An example of displaying the aggregated data using a CrossTab item is provided in the ProductSales report available in the Telerik Reporting installation folder ([installation folder]\Progress\Telerik Reporting [version]\Report Designer\Examples).

    For additional reference, check Understanding Crosstab Areas help article.

     

    Regards,
    Katia
    Progress Telerik

    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
  3. P
    P avatar
    12 posts
    Member since:
    Jul 2019

    Posted 03 Feb Link to this post

    Hi again,

    I tried also with the crosstab but to no avail. I do not need column groups or nested row groups.

    I can't figure out how to show the summary data on one row only. The closest I got was to show the distinct positions with their count but on different rows. See attached file.

    How could I get the summary at one go, maybe the logic would be something like that:

    = Join(', ', AllDistinctValues(Fields.Position) + ' - ' + Count(Fields.Position))

     

  4. P
    P avatar
    12 posts
    Member since:
    Jul 2019

    Posted 05 Feb Link to this post

    Is this scenario even possible in the standalone deisgner itself or the data needs to be retrieved with calculations and summary already done in sql? I am asking because in my case the client himself is supposed to create the report in the report designer without having to write sql queries over the data. 

  5. Katia
    Admin
    Katia avatar
    714 posts

    Posted 06 Feb Link to this post

    Hi,

    To show the summary details in one row only, you can use a nested data item that uses column grouping by the Position field. Check the attached report as a reference.

     

    Regards,
    Katia
    Progress Telerik

    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
  6. P
    P avatar
    12 posts
    Member since:
    Jul 2019

    Posted 11 Feb Link to this post

    Hi,

    Thank you for the attached example. As I can see the outcome I had in mind is not quite possible with the designer. The example shows the summary data in columns, not as text. In my case there would be a lot of such columns with spaces between them which do not suit the requirements I have to fulfil. 

    Best Regards

  7. Katia
    Admin
    Katia avatar
    714 posts

    Posted 14 Feb Link to this post

    Hi,

    The most common scenario is to display an aggregated result for a group instance per single row or column. I can see that your requirement is to accumulate all the aggregates for each position group instance in one row which cannot be achieved using the built-in expressions as they do not support nested aggregate functions.

    A possible solution is to aggregate the data prior to supplying it to the report. Another custom approach is to create a custom function that will take the aggregated data as a parameter and return it in the required format and to use this function in the expression.

     

    Regards,
    Katia
    Progress Telerik

    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