Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle View and Crystal Reports

Re: Oracle View and Crystal Reports

From: cory.swartz <cory.swartz_at_icmatls.com>
Date: 26 Apr 2007 11:52:50 -0700
Message-ID: <1177613570.850128.188150@t39g2000prd.googlegroups.com>


On Apr 25, 2:14 pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> cory.swartz schreef:
>
>
>
>
>
> > From
> > CMDSERIES.ORDR,CMDSERIES.ORDL,CMDSERIES.PROJ,CMDSERIES.EMPL,CMDSERIES.PLNT
> > WHERE
> > ((CMDSERIES.ORDR.CUST_CODE=CMDSERIES.PROJ.CUST_CODE)
> > AND(CMDSERIES.ORDR.ORDER_DATE=CMDSERIES.ORDL.ORDER_DATE)
> > AND(CMDSERIES.ORDR.PROJ_CODE=CMDSERIES.PROJ.PROJ_CODE)
> > AND(CMDSERIES.ORDR.ORDER_CODE=CMDSERIES.ORDL.ORDER_CODE)
> > AND(CMDSERIES.ORDR.SLSMN_EMPL_CODE=CMDSERIES.EMPL.EMPL_CODE)
> > AND(CMDSERIES.ORDR.PRICE_PLANT_CODE=CMDSERIES.PLNT.PLANT_CODE))
> > =============================================
>
> > The issue I have is there are records in the ORDR table that do not
> > have an ORDR.PROJ_CODE value. I still want to display these values in
> > my report, but they do not show up. When I remove the
> > AND(CMDSERIES.ORDR.PROJ_CODE=CMDSERIES.PROJ.PROJ_CODE) line from the
> > view, I get tons of repeating values. I've tried outer joins, but to
> > no avail. I'm lost at this point and any assistance would be greatly
> > appreciated.
>
> > Thanks.
>
> Use an outer join; the plus sign comes on the missing data
> side of the equasion: CMDSERIES.ORDR.PROJ_CODE=ORDR.PROJ_CODE(+)
> In recent versions, the ANSI vesrion (.. .outer join on...) is
> also supported - your version: NULL
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...- Hide quoted text -
>
> - Show quoted text -

apologies for the double post... seems like our IT dept has web caching enabled somewhere.

Thanks for the info! Received on Thu Apr 26 2007 - 13:52:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US