LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » SQL Server Database Administration » Integration Services (SSIS) and DTS » Pleae help - SSRS SUM of Distinct Value

Pleae help - SSRS SUM of Distinct Value

Options

Previous Topic · Next Topic

rgm3159

Posted: Saturday, January 22, 2011 5:42:18 PM

Rank: Newbie

Joined: 6/8/2010
Posts: 4
Points: 12
Where do you live?: NJ

Hi Scott and Everyone,

Can you please help me in SSRS:

sample preview of Detail data (no group) from stored proc:

StudentId TestScoreMath CurriculumEnrolled EnrollStatus
100 200 Nursing Withdraw
100 200 Physical Therapy Enrolled
200 100 Database Enrolled
-----
Total TestScoreMath 300

Total Student TestScoreMath should be 300 not 400

How can I SUM the value of TestScore of distinct student?

Thank you and please help.

Scott Whigham

Posted: Monday, January 24, 2011 3:52:06 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 476
Points: 1,053
Where do you live?: Dallas, TX

Well, you can do it in SSRS or in just plain SQL: what's your preference? In either way you need to SUM(TestScore) and GROUP BY StudentId, CurriculumEnrolled, EnrollStatus

rgm3159

Posted: Monday, January 24, 2011 8:09:28 AM

Rank: Newbie

Joined: 6/8/2010
Posts: 4
Points: 12
Where do you live?: NJ

Hi Scott,

I need to do it in SSRS because I cannot use group by in SQL Stored proc because I need to show all the row details. I did purchase your SSRS 2008 and trying to find out a sample like that.

Thank you.

RGM

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.