Skip to main content
Known Participant
October 19, 2014
Question

Cfspreadsheet

  • October 19, 2014
  • 1 reply
  • 524 views

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

This topic has been closed for replies.

1 reply

EddieLotter
Inspiring
December 1, 2014

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.