Webmaster Forum / ColdFusion / Advanced Techniques / October 2007

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!