Hello Community Members,
I've written a query that generates Cross Tab or Pivot. Image Below. My Query is as follows
Please clarify. Do you mean you want to create output that DOES look like the dump (hours horizontally), or which inverts things (hours vertically)? Or do you mean something else by pivot? (I do see the sql doing a pivot, of course.)
Also, how are you wanting the output to appear? As html? As a PDF? As a spreadsheet? Cf supports them all, and with multiple options for each. What have you tried?
Finally, what version of CF are you using?
Could you explain what you mean by