OraFAQ Forum: Reports & Discoverer » Re: Parameter input changes report main heading

Home » Developer & Programmer » Reports & Discoverer » Re: Parameter input changes report main heading

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Parameter input changes report main heading [message #88569]

Tue, 19 November 2002 10:53

F. Tollenaar
Messages: 64
Registered: November 2002

Member

Connect to db first ! That's causing the error-message.

There is also a logical error in your query; don't include to_char in text-literal:

 select decode(:P_TransactionType, 'Remove from UPA', 'UPA Details Removed by Transaction Code'
                                 , 'Deposit to UPA', 'Deposit to UPA Summary for '||to_char(:P_Effective_Date, 'mm/dd/yyyy'))

The way you code it, the output would not include a date, but the literal [[Deposit to UPA Summary for ||to_char(:P_Effective_Date, "mm/dd/yyyy")]]

See the difference ?

hth
Frank

Report message to a moderator

Previous Topic:	mail merge
Next Topic:	Re: Parameter input changes report main heading

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 15:48:58 CST 2024