Highlighted

how do I display Results Horizontally

Explorer ,
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

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.

TOPICS
Reporting

Views

307

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

how do I display Results Horizontally

Explorer ,
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

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.

TOPICS
Reporting

Views

308

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
Mar 20, 2015 0
Advocate ,
Mar 23, 2015

Copy link to clipboard

Copied

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
Reply
Loading...
Mar 23, 2015 0