From: windosab@yahoo.com   
      
   Dear all,   
      
      
      
   I am a new in using Crystal Report.   
      
   I'm trying to add this query in CR :   
      
   SELECT   
      
       DETILPERMF."A_NUM",   
      
       MIN(DETILPERMF."CALL_START"),   
      
       MAX(DETILPERMF."CALL_END"),   
      
       SUM(DETILPERMF."TOT_CALL"),   
      
       SUM(DETILPERMF."TOT_DUR")   
      
   FROM   
      
       "GENOB"."DETILPERMF" DETILPERMF,   
      
       "GENOB"."REJPROCESSLOG" REJPROCESSLOG   
      
   WHERE   
      
       DETILPERMF."MANAGED_FILE_ID" =   
      
       REJPROCESSLOG."MANAGED_FILE_ID"   
      
   GROUP BY   
      
       DETILPERMF."A_NUM"   
      
      
      
   But after i added it, CR keep returned/changed the query to :   
      
   SELECT   
      
       DETILPERMF."A_NUM",   
      
       DETILPERMF."CALL_START",   
      
       DETILPERMF."CALL_END",   
      
       DETILPERMF."TOT_CALL",   
      
       DETILPERMF."TOT_DUR"   
      
   FROM   
      
       "GENOB"."DETILPERMF" DETILPERMF,   
      
       "GENOB"."REJPROCESSLOG" REJPROCESSLOG   
      
   WHERE   
      
       DETILPERMF."MANAGED_FILE_ID" =   
      
       REJPROCESSLOG."MANAGED_FILE_ID"   
      
   ORDER BY   
      
       DETILPERMF."A_NUM" ASC   
      
      
      
   I dont understand why CR always changed the query. In Oracle Developer,   
   the query wont be changed.   
      
   What i'm trying to do is, i want to view the date from minimum start   
   date (call_start) until maximum end date (call_end) and summarize the   
   call (call_tot) and duration (dur_tot) per A number (A_num). for that, i   
   should group by the A_num. May be, there is a way from CR role to group   
   by field(s), but yet, i need advices how to do it.   
      
      
      
   Any help would be helpfull. Thank you.   
      
      
      
   rgds,   
      
   windos   
      
      
   --   
   -   
      
      
   Posted via http://dbforums.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)