How to looping on student grades to check if he has one fail course?

I want report that display student who are Withdrawn from (all) courses in specific academic period and his registration status are registered but the student course column display even if he has at least one Withdrawn course since there is no loop in Cognos how can I restrict it only if the student withdrawn from all courses
thank you

Showing Answers 1 - 2 of 2 Answers

Buchi Reddy

Jul 18th, 2014

1. Take one data item with the expression of (Count of Subjects) for Student

2. case when (Count of Subjects) for Student =0 then student end