Creating a formula? 1

[Jetter88]

I'm trying to create a formula field for my report. The formula field is to combine 2 fields together. In my case... the area code and phone number.

am I going in the right direction?

I'm new to Oracle reports so any help is appeciated.

thanks in advanced!

 

[BJCooperIT]

Yes, a formula field can do what you want. In the data model create your formula field in the same group as the Area Code and Phone Number. Set the datatype and width on the Property Inspector. Create the PL/SQL formula with code similar to:

return('('||:AREA_CODE||') '||:PHONE_NBR);

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: Emu Products Plus

 

[Jetter88]

Thanks BJCooperIT!

This worked perfectly! Excellent explanation on how to do it too!

i'll probably have more in the future!