Copy link to clipboard
Copied
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
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.
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.