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

qoq summary rows

Advisor ,
Jan 26, 2016 Jan 26, 2016

Hi All,

I have a complex query putting multiple tables and views data using union all, such as:

<cfquery name="preQry" dbtype="query">

select 'groupA' as Grouping, Item as Desc, sum(fieldCalA) as fielTotal

from tableA

group by Grouping, Desc

union all

select 'groupB' as Grouping, item as Desc, sum(fieldCalA) as fielTotal

from viewB

group by Grouping, Desc

.....

</cfquery>

The data looks like:

GROUP, DESCRIPTION, TOTAL

----------------------------------------------

groupA, ItemA, 10

groupA, ItemB, 25

groupB, ItemC, 30

groupB, ItemD, 20

groupB, ItemE, 50

groupC, itemF, 5

....

How can I add a summary row in my qoq? so my data can be like:

DESCRIPTION, TOTAL

--------------------------------

groupA, 35

   ItemA,10

   ItemB, 25

groupB, 100

  ItemC, 30

  ItemD, 20

  ItemE, 50

groupC, 5

  ItemF, 5

....

Thanks in advance.

239
Translate
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
no replies

Have something to add?

Join the conversation
Resources