Re: Problem on Viewing SQL in Crystal Report

Hi,
as far as I know and been testing, Crystal Reports manages Oracle functions and Group by Aggregates very badly...

one of the easiest solution consist in creating a view in the Oracle DB with your query and then base your Report in CR directly from the view...

hope this helps !

Gilles

"windos" <windosab_at_yahoo.com> a écrit dans le message de news:3306046.1062238957_at_dbforums.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
Received on Sat Aug 30 2003 - 21:56:30 CEST