Groupinig using Lists in a report

• Jason Wilks

  Old Hand

  Points: 389

  More actions

  August 12, 2022 at 10:01 pm

  #4075896

  I am trying to create a list type report and can't seem to get the groupings correct. I am using VS 2017.

  Here is the data set:

  student_id full_name dob email note session_desc Percentage
  6 Test Student 2008-07-24 Sample email Sample Note Main Session 1 59.5
  6 Test Student 2008-07-24 Sample email Sample Note Main Session 2 61.5
  6 Test Student 2008-07-24 Sample email Sample Note Main Session 3 66.9
  6 Test Student 2008-07-24 Sample email Sample Note Main Session 4 64.9

  I am trying to get the report to look like this:

  At the top I have a rectangle with the parent group and below the detail records with a line chart to show improvement each session:

  

   

  This format would repeat for each student in the dataset. I am trying to use lists, but everything I have tried repeats the Student,dob,email info for the detail records.

  • This topic was modified 2 years, 4 months ago by  Jason Wilks.

• Jason Wilks

  Old Hand

  Points: 389

  More actions

  August 12, 2022 at 11:29 pm

  #4075908

  I figured it out.  Instead of creating a parent row group from the detail group, I have to add a group expression to the detail group itself!

  SSRS takes some getting used to - not the easiest to follow at first