Repeating row values for unique ID in SSRS report

Please take a look at below report(highlighted values are repeating for some reason)

Query:

SELECT DISTINCT EXSS_Year, STEN_Student_ID, EXSS_Student_ID, 
STUD_Forename_1, STUD_Surname, EXSS_Act_Grade, 
COUNT(Grade) AS Count_Grade, COUNT(CourseType)AS CountType, 
EXSS_Issued_Date, EXSS_Cand_No, EXSS_Awarding_Body, Awarding_body, 
EXSS_Provision_Code, PRPH_ML2, PRPH_ML1, Course, PRPH_Title, 
Section, EXSS_Provision_Instance, EXSS_Subject_Code, EXSJ_Description, CourseType, Grade
FROM FS_Exams_English
GROUP BY EXSS_Year, STEN_Student_ID, EXSS_Student_ID, 
STUD_Forename_1, STUD_Surname, EXSS_Act_Grade, 
EXSS_Issued_Date, EXSS_Cand_No, EXSS_Awarding_Body, 
Awarding_body, EXSS_Provision_Code, PRPH_ML2, 
PRPH_ML1, Course, PRPH_Title, Section, 
EXSS_Provision_Instance, EXSS_Subject_Code, 
EXSJ_Description, CourseType, Grade
ORDER BY STEN_Student_ID

Sample data for Keelan Shelly:

Forename Surname Count_Grade CountType  Section Course  PRPH_Title                        EXSJ_Description                        CourseType    Grade
Keelan  Shelly   0           0        14-16    27448/A01 English E3 FS (14-16) (Pearson)    E3 ENGLISH FUNCTIONAL SKILLS WRITING NULL          NULL
Keelan  Shelly   0           1        CSTR     27239/A01  English L1 FS (for CSTR) (CG)     FUNCTIONAL SKILLS ENGLISH           Overall        NULL
Keelan  Shelly   0           1        14-16    27448/A01 English E3 FS (14-16) (Pearson)    E3 ENGLISH FUNTIONAL SKILLS READING Reading        NULL

let me know how can I avoid this.

Answers


I would copy the results from the above query into Excel. Examine the data closely for the students that are duplicating. The data in one of the columns is not exactly the same for the students that are duplicating. It is hard to say which column is causing the duplication without actually seeing the data.

Hope this helps, Mark http://sqlreports.wordpress.com/


Need Your Help

Getting Dump from weblogic server programatically

java jmx jdeveloper mbeans

I have a requirement where I need to design a small app which contains a button. When the user clicks on that, it will connect to corresponding weblogic server and get the MDS dump ZIP file located...

Bootstrap Element Alignment

html css twitter-bootstrap

I am new to bootstrap and I am trying to discover how to align the object circled in red (in the photograph) to the right.