none
Creating a single line in a report from multiple data lines RRS feed

  • Question

  • Hi all,

     

    I'm using VS2005 and have written some SQL to produce two columns of data, for example:

    Andrew,Biology

    Andrew,Chemistry

    Belinda,Biology

    Belinda,English

    Belinda,Psychology

    etc

     

    I need to produce a report in this format:

    Andrew,Biology,Chemistry

    Belinda,Biology,English,Psychology

    etc

     

    The number of subjects being studied for each student can vary between 2 and 5. I've tried using a matrix report, but that created a column for every possible subject.

     

    Any help would be much appreciated.  I hope this is the correct forum!

     

    Brian

    Thursday, December 8, 2011 12:41 PM