1 Reply Latest reply on Oct 30, 2007 12:04 PM by Dan Bracuk

    Crosstab report from QoQ?

      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!