Skip to main content
Tayyab Hussain
Tayyab Hussain
Inspiring
March 21, 2015
Answered

how do I display Results Horizontally

  • March 21, 2015
  • 1 reply
  • 506 views

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

This topic has been closed for replies.
Correct answer EddieLotter

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.

1 reply

EddieLotter
EddieLotterCorrect answer
Inspiring
March 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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices