Creating table with mean, sd, variance

[William]

Hi:

Is it possible to create a table containing aggregate function such as mean, sd and variance?

 Basically I have a list of the following data

classID,studentID, subject, mark, date

 1,S00023,Maths,73,2015-03-03

 1,S00024,Maths,68,2015-03-03

 1,S0002​3,English,81,2015-03-05

 1,S00025,English,59,2015-03-05

...​​​

and I would like to create a table:

ClassID | Subject | Number Of Student |average Mark |SD | CV%

1            | Maths   |24                             |65                   |7.3 |2.54

2            | Maths   |18                             |​78                   |​14.3 |6.54

...

As I tried using crosstab without setting column grouping (

putting ClassID, subject as row groups, and

• count(distinct fields.studentID),
• avg(fields.mark),
• stdDevP(fields.mark),
• varP(fields.mark)

as Detail Values,  but it didn't work.

 Can I ask how it could be done with the designer please?

 Many thanks

 Regards

 William

 

 

[Nasko]

Hello William,

Your data can be represented with the Reporting Table item. Start the Table Wizard from the Toolbox items in Visual Studio or from the Standalone Report Designer menu and follow the wizard steps to configure the table.
After the Table item is configured select it and open the Group Explorer window. There you need to add a parent group of the Detail group which will contain the totals/aggregates. You can add the aggregate functions in this newly added group.

Regards,
Nasko
Telerik

[William]

Hi Nasko:

 Thanks, but I am not too familiar with the group explorer, any chance you could us with a quick example please?

 Many thanks

Regards

 William