Groupinig using Lists in a report

  • 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:

    report

     

    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 1 month, 1 week ago by  Jason Wilks.

    Microsoft Certified Professional: MCSE Data Management and Analytics

  • 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

    Microsoft Certified Professional: MCSE Data Management and Analytics

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply