Problem on Viewing SQL in Crystal Report

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