https://forums.adobe.com/community/coldfusion/coldfusion_advanced?view=discussions Most recent forum messages en Sun, 19 Oct 2014 02:00:26 GMT Jive Engage 7.0.0.1 (http://jivesoftware.com/products/) 2014-10-19T02:00:26Z en https://forums.adobe.com/message/6843970?tstart=0#6843970 <!-- [DocumentBodyStart:9f01dc08-89ba-4dc2-a83f-e0187beba732] --><div class="jive-rendered-content"><p>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:</p><p style="min-height: 8pt; padding: 0px;">&nbsp;</p><p>The spreadsheet could look like this:</p><p style="min-height: 8pt; padding: 0px;">&nbsp;</p><p>First Name-------------Last Name-------------Organization-------------Address-------------City-------------State----- --------Zip-------------Concern</p><p>Joe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Smith&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sample&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12 main&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; denver&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; co&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80513&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; concerns go here</p><p style="min-height: 8pt; padding: 0px;">&nbsp;</p><p>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?</p><p style="min-height: 8pt; padding: 0px;">&nbsp;</p><p>Thanks,</p><p style="min-height: 8pt; padding: 0px;">&nbsp;</p><p>Steve</p></div><!-- [DocumentBodyEnd:9f01dc08-89ba-4dc2-a83f-e0187beba732] --><img src='/beacon?t=1415919216567' /> Sun, 19 Oct 2014 01:18:26 GMT forums_noreply@adobe.com https://forums.adobe.com/message/6843970?tstart=0#6843970 2014-10-19T01:18:26Z 3 weeks 5 days ago 0