OraFAQ Forum: Reports & Discoverer » Creating a letter - self populated fields but free text body

Home » Developer & Programmer » Reports & Discoverer » Creating a letter - self populated fields but free text body (Oracle Reports)

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

Creating a letter - self populated fields but free text body [message #636581]

Tue, 28 April 2015 09:24

teagemini
Messages: 5
Registered: November 2014
Location: Nova Scotia

Junior Member

hi

I'm creating an official work letter and it has a number of self populating fields (ie name, address, case number). It needs to be a free text body so that when a member of staff inputs the parameters, the form will open with the pre-populated fields and they can type in the body of the letter with any text they need to in any length of paragraphs (so it may even fall onto page 2). The pre-populated signature will also have to sit underneath the body of the text.

I've already created the letter with the letter head and parameters so that when the user opens the letter, it will have their pre-populated fields in there but I have no idea how to create a body of text that will accept free text when report is opened and then expand with the signature beneath it.

Can anyone point me in the right direction as to how I can achieve this please as I'm a newbie at reports? I read about 'fillable' pdf software but is there a way it can be done in oracle reports and no third party software?
Thank you Smile

Report message to a moderator

Re: Creating a letter - self populated fields but free text body [message #636608 is a reply to message #636581]

Wed, 29 April 2015 01:36

Littlefoot
Messages: 21781
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'd use a form (developed with Oracle Forms Builder) which enables you to create letter body. Then, call the report from that form.

The signature is, I presume, a scanned image. Just create a field at the bottom of the report. If it is stored on the application server, report's query will have to SELECT image name (such as "signature.jpg"; field's properties: "Read from file" will be "Yes", "File format" will be "Image".

Report message to a moderator

Re: Creating a letter - self populated fields but free text body [message #636633 is a reply to message #636608]

Wed, 29 April 2015 09:24

teagemini
Messages: 5
Registered: November 2014
Location: Nova Scotia

Junior Member

Thank you....I'll try that Smile

Report message to a moderator

Previous Topic:	Group Left report sort DESCending order (report 6i) (merged)
Next Topic:	Print three copies of report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 21 14:46:52 CDT 2023