SSRS MATRIX GROUP SUM issue - reg

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

SSRS MATRIX GROUP SUM issue - reg

Author

Topic

kannaKanagaraj
Starting Member

1 Post

Posted - 2013-04-11 : 05:08:03

Dear all,

We are facing problem in SSRS Matrix report while sum the Fields.it shows duplicate values, as well as report rendering time in front end takes
5mins for 600000 records though it runs in DB takes 51 seconds only.

Data set structure example

Schools Rubric Subjects Ratings Score
101 TCH math’s H 1
101 TCH Tamil H 1
101 TCH math’s E 2
101 MED math’s D 1
101 GUD math’s U 3

WE NEED TO SUM THE RATINGS SUM LIKE
SCHOOL => Rubric =>Subjects=>H =SUM (SCORE)
SCHOOL => Rubric =>Subjects=>E =SUM (SCORE)
SCHOOL => Rubric =>Subjects=>D =SUM (SCORE)
SCHOOL => Rubric =>Subjects=>U =SUM (SCORE)

Kindly give your best advice.

Regards,
Kannappan

kanna

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-04-12 : 05:10:16

You want them to come side by side or in a hiererchy format? like


SCHOOL1
    Rubric1
          Subject1  Rating1  SUM
          Subject2  Rating2  SUM
    Rubric2
          Subject1 Rating3  SUM
SCHOOL2
..

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources