title: Displaying multiple records of one column in a single jasperreport
body: <p>I am using jasper report 5.0.0 and creating a report with a scenario as described below:
  In my ireport I need to display a students name, class, id, goal, proficiencyForGoal. For each student there are multiple goals and for each goal there is progress. My sql query is as following :
  select stud.name, stud.class, stud.id, prog.goal_id, prog.proficiency from 2 or 3 tables which are joined and group by prog.goal_id. This query gives multiple rows per student. And the ireport creates multiple PDFs(using PDF Preview) per row. <strong>But I want to display all goals and the goals proficiency along with student details like name, class, id in a single PDF</strong>. That is I want one PDF per student with all the details. So if there are 500 students then 500 pdfs.</p>
  
  <p>Suppose there are 10 goals per student then right now what I am getting is 10 PDFs for one student with name, class, id repeating and for 500 students I am getting 500*10=5000 pdfs WHICH I DONT WANT.</p>
  
  <p>Appreciate your quick input or ideas on how to achieve this requirement.</p>
  
  <p>Thanks</p>