Highlighted

Cfspreadsheet

Explorer ,
Oct 18, 2014

Copy link to clipboard

Copied

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

TOPICS
Advanced techniques

Views

394

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Cfspreadsheet

Explorer ,
Oct 18, 2014

Copy link to clipboard

Copied

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

TOPICS
Advanced techniques

Views

395

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Oct 18, 2014 0
Advocate ,
Dec 01, 2014

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Dec 01, 2014 0