Creating a training grid

[lrundquist]

I have a table that houses training information, essentially date, training time, and training event. I am trying to create a cfgrid that will transpose it into a grid with training time as the vertical axis and date as the horizontal axis, with the appropriate training event inside the grid, like this:

9/15 9/16 9/17 9/18 ...
0600-1000 Group A Tng X Group A Tng Y Group A Tng Z Group A Final Exam ...
1000-1400 Group B Tng A Group B Tng B Group B Tng C Group C Tng A ...
.
.
.

It's essentially a pivot table grouped on training time and date, but I cannot seem to get it to work in CF MX7. Any ideas?

Thanks for your help!

Lars

[azadisaryev]

i do not think cfgrid allows you to create a 'pivot table'... you can check out the following tutorial:
http://labs.redbd.net/blog/index.cfm/2006/9/4/Build-a-Pivot-Table-in-ColdFusion-in-four-easy-steps

or this custom tag (free opensource):
http://labs.redbd.net/blog/index.cfm/2006/8/8/Open-Source-Datagrid

Azadi