Question
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!
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!