How to show summary info from rows

[P]

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

[Katia]

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

[P]

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))

 

[P]

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. 

[Katia]

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

[P]

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

[Katia]

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