Row alignment

• Magy

  SSCarpal Tunnel

  Points: 4217

  More actions

  April 7, 2016 at 1:48 pm

  #306263

  I created a report that shows quiz selections by student.

  However, each grouping answers for each user is on a separate row.

  Is there a way to line up each row ?

  You can see what I mean here:

  

  https://www.sqlservercentral.com/Forums/Uploads/image-unavailable.png

  Thanks

• dbursey

  Right there with Babe

  Points: 781

  More actions

  April 11, 2016 at 9:05 am

  #1871173

  Try column grouping on your answers? I just discovered column grouping, so I am not an expert by any means, but it seems like that would work.

• tindog

  SSCarpal Tunnel

  Points: 4892

  More actions

  April 11, 2016 at 9:08 am

  #1871174

  What does the output of your dataset look like? (And perhaps share the query in case the issue can be resolved there)

  What are you currently grouping by (first name I'd guess)?

  LinkedIn