Home » Developer & Programmer » Reports & Discoverer » Re: Parameter input changes report main heading
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
Previous Topic: mail merge
Next Topic: Re: Parameter input changes report main heading
Goto Forum:
  


Current Time: Mon May 16 19:11:28 CDT 2022