Getting data from multiple rows on one database field column RRS feed

  • Question

  • User2028249543 posted


    I need to know if there is a possibility of getting data from multiple rows on one database field column.

    Screenshot references:



    The first link shows my EducLevelName column having values of Elementary, HighSchool, College & Graduate while SchoolName points to the values of Colegio de la Immaculada Conception, Saint Louis College-Cebu (formerly SLSM), University of San Carlos (Main campus), etc.

    The second link is my design report of Cystal report. I simply drag the database columns EducLevelName & SchoolName from the Field Explorer to my designer. My very concern is how can we display all those values on one single column like SchoolName to show all schools under that column?

    Do we need to loop these column names in code behind or what possible options do we need to do in order to show off those values?

    Please help. Thanks.

    Sunday, February 5, 2012 9:56 PM


  • User-37275327 posted

    Format your report in to multiple columns, and fields to each columns

    right click on detail section > section expert > Format with multiple columns> on the lay out tab set column width.

    But i am sure thats what you are looking for!

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, February 10, 2012 5:09 AM