Skip to main content
Participant
October 30, 2007
Question

Crosstab report from QoQ?

  • October 30, 2007
  • 1 reply
  • 301 views
How do you create a crosstab report similar to MS Access, from a Query of Query in ColdFusion MX?

I initially query a huge Sybase DB four different ways then merge the four record sets with a QoQ in ColdFusion into one record set with fields A, B, and C the value. I want to cross A of the row and B as the column and display C as the value in the cell of spreadsheet type tabular report in a browser. The Sybase DB is too large to combine all the criteria into one query and do the code in T-SQL.

Thanks in advance for any help!
This topic has been closed for replies.

1 reply

Inspiring
October 30, 2007
I don't think Q of Q can do this. The last time I had to do something like that I constructed a 2D array and outputted that.