Cfspreadsheet

[pmlink360]

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

[EddieLotter]

It can be done in ColdFusion code, but it would be much better to handle it in your database query, for example by using a scalar function to concatenate the concerns.