how do I display Results Horizontally

[Tayyab Hussain]

Hi-

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

Zone_ID	Zone_Name	No. of Emplyees
1	A	47
2	B	65
3	C	100
4	D	32

But I want to disply the results Horizontally

Zones	A	B	C	D
No of Employees	47	65	100	32

Any Ideas how to do so??

Thanks

[EddieLotter · Accepted solution]

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.