469,612 Members | 2,639 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,612 developers. It's quick & easy.

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
Jul 19 '05 #1
2 3607
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

Jul 19 '05 #2
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

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by mharris | last post: by
3 posts views Thread by Milan Todorovic | last post: by
reply views Thread by Shahid Juma | last post: by
reply views Thread by David P. Donahue | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.