Hi

when we use the
A
B
C
BY D

The normal output will be

D A
B
C

But my desired output should b e


D A
D B
D C

i have to group by D only

How to achive this formnat?

Thanks in Advance ...

SET BYDISPLAY = ON

Hi,

Please use:

PRINT D
      A
      B
      C
BY D NOPRINT
END

Hi Ricky

Where can i use the SET BYDISPLAY = ON ? In Stule sheet ? or anywhee else

i am using this code


SQL SQLMSS
SELECT * FROM ;


TABLE FILE SQLOUT

PRINT
*
ON TABLE HOLD
END

TABLE FILE HOLD
PRINT
Full_Name AS ''
Account
Branch_Name AS ''
BY EndDate
END



Where can i use SET BYDISPLAY = ON ?

Hi Shrikant

It is not working

Again i got

D A
B
C

Only i got

Gobinath

Rick's suggestion is ok, but in the code you have to say

TABLE FILE HOLD
PRINT 
Full_Name AS ''
Account
Branch_Name AS ''
BY EndDate
ON TABLE SET BYDISPLAY ON 
END

The other suggestion is also ok if you do

TABLE FILE HOLD
PRINT 
EndDate
Full_Name AS ''
Account
Branch_Name AS ''
BY EndDate NOPRINT

END

Thanks Guys

It is working Fine.