1 Reply Latest reply on Dec 1, 2014 3:44 PM by EddieLotter

    Cfspreadsheet

    pmlink360 Level 1

      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