Reports 6.0

[Quoted]
• ORDERING NOT POSSIBLE ON GROUP FIELDS in Reports 6.0 **

There is a table with attributes PERSON_NAME CITY COUNTRY AGE and a report is created to list all the fields. Group fields are COUNTRY and CITY. The fields are ordered by COUNTRY, CITY and PERSON_NAME.

Query : select country,city,person_name,age from table_1 order by

        country,city,person_name.

 The output looked like

  INDIA      DELHI        MALAR  20
                          RAJA   30
             AHMEDABAD    KUMAR  35
                          PRABHU 40
             CHENNAI      KAMAL  48
                          RAJINI 50
 AUSTRALIA   MELBOURNE    ASHOK  23
                          BALA   25
 SRILANKA    COLOMBO      MURALI 29

 If you notice the output,
   PERSON_NAME is in alphabetic order, as expected;    but the group fields COUNTRY and CITY do not follow any order.

 Later i included order by COUNTRY, CITY to the query. But it didn't have any effect on the output.

 Does it mean order by does not work on the group by fields set in the  report wizard??

 If no group fields are set in the report wizard, order by has effect on  COUNTRY and CITY. But the output is in an undesirable format as in.

 AUSTRALIA MELBOURNE ASHOK 23
 AUSTRALIA MELBOURNE BALA 25

 INDIA       AHMEDABAD    KUMAR  35
 INDIA       AHMEDABAD    PRABHU 40
 INDIA       CHENNAI      KAMAL  48
 INDIA       CHENNAI      RAJINI 50
 INDIA       DELHI        MALAR  20
 INDIA       DELHI        RAJA   30
 SRILANKA    COLOMBO      MURALI 29

 Could anyone tell me how to change the query to order the group fields  with the output as in the first format?

 Any help would be appreciated!.
 regards
 Rajini

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 06 1999 - 23:47:24 CEST