0 Replies Latest reply: Oct 18, 2014 7:00 PM by pmlink360 RSS

    Cfspreadsheet

    pmlink360 Community Member

      Hi, I have a question regarding cfspreadsheet....So I'm using cfspreadshseet to create excel spreadsheets for reporting purposes. My page allows a user to select whatever columns from the database to include in the report. So here is an example:

       

      The spreadsheet could look like this:

       

      First Name-------------Last Name-------------Organization-------------Address-------------City-------------State----- --------Zip-------------Concern

      Joe                           Smith                          Sample                      12 main                 denver            co                  80513               concerns go here

       

      My question is this, if Joe has more than 1 concern I get multiple rows with joe's info...is there a way I can loop the concerns and only have 1 row for joe?

       

      Thanks,

       

      Steve