Problem on Viewing SQL in Crystal Report

[windos]

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

[Gilles Mercier]

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" <wi******@yahoo.com> a écrit dans le message de
news:33****************@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

[paul sun]

remember, you can do your way both in database side and crystal side.
eg: in crystal side, you can create a function to sort it out. you
will get loads of help from crystal help!

good luck!

"Gilles Mercier" <gi************@urbanet.ch> wrote in message news:<3f******@news.swissonline.ch>...

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" <wi******@yahoo.com> a écrit dans le message de
news:33****************@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