SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Reporting Services Development
 SSRS MATRIX GROUP SUM issue - reg
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kannaKanagaraj
Starting Member

1 Posts

Posted - 04/11/2013 :  05:08:03  Show Profile  Reply with Quote
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

India
52309 Posts

Posted - 04/12/2013 :  05:10:16  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000