CLSTS CLMST CLCTO CLART CLUB1 CLUB2 CLUB3 CLLSI
A 40 34815 0080502 A01 002 1955
A 40 34815 0080501 A01 003 1955
A 40 34815 0080505 A01 003 1955
A 40 34815 0080501 A01 003 1956
If I run this Sql statement
SELECT CLMST, CLCTO, CLUB1, CLUB2, CLUB3, CLART, cllsi , sum(ClQis)
as Tot,
Grouping(CLMST) As mst,
Grouping(CLCTO) As Cto ,
Grouping(CLart) As Art,
Grouping(CLUB1) As Ub1,
Grouping(CLUB2) As Ub2,
Grouping(CLub3) As Ub3,
GROUPING(cllsi) as lsi
FROM OCLLw00F WHERE CLSTS <>
'C' GROUP BY ROLLUP
( CLMST, CLCTO, CLUB1, CLUB2, CLUB3, CLART, cllsi
)
ORDER BY CLMST, CLCTO, CLUB1, CLUB2, CLUB3, CLART, cllsi
My problem is : why there is not the break when the col "art." Change from
0080501 to 0080505 ?
Where am I wrong ?
Thanks in advance (hoping to be clear !!)
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.