• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Crosstab report from QoQ?

Community Beginner ,
Oct 30, 2007 Oct 30, 2007

Copy link to clipboard

Copied

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!
TOPICS
Advanced techniques

Views

269

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Oct 30, 2007 Oct 30, 2007

Copy link to clipboard

Copied

LATEST
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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation