how do I display Results Horizontally

Explorer ,
Mar 20, 2015 Mar 20, 2015

Copy link to clipboard

Copied

Hi-

Coldfusion Report Builder by default displays result vertically, say, somthing like this:

Zone_IDZone_NameNo. of Emplyees
1A47
2B65
3C100
4D32

But I want to disply the results Horizontally

ZonesABCD
No of Employees476510032

Any Ideas how to do so??

Thanks

TOPICS
Reporting

Views

317

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
community guidelines

correct answers 1 Correct Answer

Advocate , Mar 23, 2015 Mar 23, 2015
Craft your database query to return the result set in the format that you describe. This will make your report design very simple.To create the desired result set that you gave in your post, research the term "pivot" or "cross tabulation" to find out how to do it using your database engine of choice.

Likes

Translate

Translate
Advocate ,
Mar 23, 2015 Mar 23, 2015

Copy link to clipboard

Copied

LATEST

Craft your database query to return the result set in the format that you describe. This will make your report design very simple.

To create the desired result set that you gave in your post, research the term "pivot" or "cross tabulation" to find out how to do it using your database engine of choice.

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
community guidelines