Fw: Oracle reports

Fw: Oracle reports

 

  


Kind Regards

Syed Massi Uddin

IT Manager
Sharief Group
PO Box: 4446
Dubai
UAE
Email: [Email address protected]
Mob: +971 50 7594187
Tel: +971 4 336 2224
Fax: +971 4 336 2333


CONFIDENTIALITY: The contents of this email (and of any attachments) are
intended for the designated recipient only, may be confidential and may
contain copyright material of Mohd Sharief & Bros or third parties.
You may only reproduce or distribute the contents if you are the designated
recipient of this e-mail, and then only for the purposes that we have
expressly authorised, or which are clearly implicit from the context
in which we have sent it to you. This authorisation is limited to those
purposes, and may be revoked by us at any time.

Fax:- 04-3362333
----- Original Message -----
From: "Syed Massi" <[Email address protected]
To: "Nilesh Patel" <[Email address protected]
Sent: Thursday, June 29, 2006 9:42 AM
Subject: Re: Oracle reports


> Hi,
>
> I tried to assign Opnbal to PlaceHolder I getting error
>
> 'Rep-1217 place holder 'Cp-dbph' reference one or more non-formula
coloumns'
>
> my query to openbal is
>
> function CP_1Formula return Number is
> Vperiod_name VARCHAR2(40);
> begin
> declare
> per_start_cre number;
> per_start_deb number;
> begin
> Vperiod_name :=
> TO_CHAR(TO_DATE(SUBSTR(:P_START_DATE,1,10),'yyyy/mm/dd'),'MON-YYYY');
> get_start_balances(Vperiod_name,
> per_start_deb,
> per_start_cre);
> return(per_start_deb);
> end;
> RETURN NULL;
> end;
>
> Kind Regards
>
> Syed Massi Uddin
>
> IT Manager
> Sharief Group
> PO Box: 4446
> Dubai
> UAE
> Email: [Email address protected]
> Mob: +971 50 7594187
> Tel: +971 4 336 2224
> Fax: +971 4 336 2333
>
>
> CONFIDENTIALITY: The contents of this email (and of any attachments) are
> intended for the designated recipient only, may be confidential and may
> contain copyright material of Mohd Sharief & Bros or third parties.
> You may only reproduce or distribute the contents if you are the
designated
> recipient of this e-mail, and then only for the purposes that we have
> expressly authorised, or which are clearly implicit from the context
> in which we have sent it to you. This authorisation is limited to those
> purposes, and may be revoked by us at any time.
>
> Fax:- 04-3362333
> ----- Original Message -----
> From: "Nilesh Patel" <[Email address protected]
> To: <[Email address protected]
> Sent: Wednesday, June 28, 2006 8:49 AM
> Subject: Re: Oracle reports
>
>
> > **A LazyDBA.com subscriber has responded to your lazydba.com post**
> > **LazyDBA.com mail shield has forwarded you this email,
> > **and removed any attachments, and kept your email address secret
> > **from this person, and any viruses/trojans.
> > **If you reply to this email, the person will see your email address as
> normal
> > **Anything below this line is the original email text
> >
> >
> > I think this should solve it is :
> > create a place-holder column and assign it the opening balance
> > then in the transactions frame have a runing total by a summary column
> > then in the transaction query group create a formula column and get the
> > value of the placeholder column of opening bal.
> > to this add the value fro summary column and return value
> > add field in tranaction frame and source value from formula column from
> > transaction query group ....
> >
> > cheers
> >
> > -------------------------------------------
> > With Kind Regards
> > Nilesh Patel
> > Contel Application
> > Phone (07) 3327 9810
> > Mobile 0405 200 181
> > ------------------------------------------
> > ----- Original Message -----
> > From: "Syed Massi "
> > [Email address protected]
> > To: "LazyDBA Discussion" [Email address protected]
> > Sent: Wednesday, June 28, 2006 2:51 PM
> > Subject: Oracle reports
> >
> >
> > > Dear All Developers,
> > >
> > > I am developing oracle report
> > > I have to add openingbalance of debit + total of all tranactions for a
> > particular date range as my opening balance and all tranaction total are
> in
> > different frames and different groups
> > >
> > > when i try to add both the fields it gives me error
> > >
> > >
> > > Kind Regards
> > >
> > > Syed Massi Uddin
> > >
> > > IT Manager
> > > Sharief Group
> > > PO Box: 4446
> > > Dubai
> > > UAE
> > > Email: [Email address protected]
> > > Mob: +971 50 7594187
> > > Tel: +971 4 336 2224
> > > Fax: +971 4 336 2333
> > >
> > >
> > > CONFIDENTIALITY: The contents of this email (and of any attachments)
> are
> > > intended for the designated recipient only, may be confidential and
may
> > > contain copyright material of Mohd Sharief & Bros or third parties.
> > > You may only reproduce or distribute the contents if you are the
> > designated
> > > recipient of this e-mail, and then only for the purposes that we have
> > > expressly authorised, or which are clearly implicit from the context
> > > in which we have sent it to you. This authorisation is limited to
those
> > > purposes, and may be revoked by us at any time.
> > >
> > > Fax:- 04-3362333
> > >
> > >
> > > --------
> > > website: http://www.LazyDBA.com
> > > Please don't reply to RTFM questions
> > > Oracle documentation is here: http://tahiti.oracle.com
> > > To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> > > To subscribe: see http://www.lazydba.com
> > > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
> > >
> > >
> >
> >
> >
> >
> >
>



Oracle LazyDBA home page