Re: Problem on Viewing SQL in Crystal Report

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" <gilles.mercier_at_urbanet.ch> wrote in message news:<3f51016f_at_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" <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 Mon Sep 15 2003 - 16:08:50 CEST