Home » Developer & Programmer » Reports & Discoverer » Issue in text formatting in oracle reports.
Issue in text formatting in oracle reports. [message #421915] Fri, 11 September 2009 12:17 Go to next message
gurusuryas
Messages: 49
Registered: March 2009
Location: Chennai
Member
Hi all,

I need the below output in oracle 10G reports , i used form letter style.

-------


&<clinet_name>
&<project_name> &<message_subject>
&<added_date>
&<message_body>

----------------

My requirement is client_name,project name and date and Message_subject in first frame, but corrseponding body message of messege_subject to be displayed in next frame.

please look into my Attachment below, and tell me some guidance.

Thanks

gurus
gurusuryas@gmail.com
  • Attachment: Doc1.pdf
    (Size: 58.15KB, Downloaded 1859 times)

Report message to a moderator

Re: Issue in text formatting in oracle reports. [message #421985 is a reply to message #421915] Sat, 12 September 2009 12:42 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Message body in another frame? Why? All fields make a single message, don't they? So what would be the purpose of your requirement?

Report message to a moderator

Re: Issue in text formatting in oracle reports. [message #422179 is a reply to message #421915] Mon, 14 September 2009 23:54 Go to previous messageGo to next message
gurusuryas
Messages: 49
Registered: March 2009
Location: Chennai
Member
ok,

please find below attachment and tell me how can i create report as like as in the attachment.


thanks

gurus
  • Attachment: print.pdf
    (Size: 55.88KB, Downloaded 1655 times)

Report message to a moderator

Re: Issue in text formatting in oracle reports. [message #422190 is a reply to message #422179] Tue, 15 September 2009 00:59 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, an ordinary Tabular style is capable of creating such a layout.

Report message to a moderator

Re: Issue in text formatting in oracle reports. [message #422194 is a reply to message #421915] Tue, 15 September 2009 01:26 Go to previous messageGo to next message
gurusuryas
Messages: 49
Registered: March 2009
Location: Chennai
Member
please write some text with small example. i did not get still.

Report message to a moderator

Re: Issue in text formatting in oracle reports. [message #422199 is a reply to message #421915] Tue, 15 September 2009 01:33 Go to previous messageGo to next message
gurusuryas
Messages: 49
Registered: March 2009
Location: Chennai
Member
I attached file below . this is created by Tabular Style .

but this is not my requirement.
  • Attachment: report.pdf
    (Size: 50.90KB, Downloaded 1720 times)

Report message to a moderator

Re: Issue in text formatting in oracle reports. [message #422202 is a reply to message #421915] Tue, 15 September 2009 01:45 Go to previous messageGo to next message
gurusuryas
Messages: 49
Registered: March 2009
Location: Chennai
Member
where i need to make changes in Web Source for required report?

Report message to a moderator

Re: Issue in text formatting in oracle reports. [message #422208 is a reply to message #422202] Tue, 15 September 2009 02:06 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Wizard creates very basic layout. In order to achieve the result you'd like to, you'll have to do some manual work. I do that in the Paper Layout Editor.

Report message to a moderator

Re: Issue in text formatting in oracle reports. [message #422237 is a reply to message #421915] Tue, 15 September 2009 04:22 Go to previous messageGo to next message
gurusuryas
Messages: 49
Registered: March 2009
Location: Chennai
Member

i could not move fields in corresponding place. please explain with one sample report if you can.

Report message to a moderator

Re: Issue in text formatting in oracle reports. [message #422290 is a reply to message #422237] Tue, 15 September 2009 06:48 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It requires basic (manual) formatting, which includes use of Flex on/off as well as Confine on/off tools. I don't know how to "explain" that, except writing a report instead of you (and that's something I can't do right now).

Report message to a moderator

Re: Issue in text formatting in oracle reports. [message #422856 is a reply to message #422208] Sun, 20 September 2009 19:30 Go to previous messageGo to next message
linlasj
Messages: 98
Registered: August 2005
Location: Linköping
Member
Littlefoot wrote on Tue, 15 September 2009 09:06
Wizard creates very basic layout. In order to achieve the result you'd like to, you'll have to do some manual work. I do that in the Paper Layout Editor.

Me too.

Report message to a moderator

Re: Issue in text formatting in oracle reports. [message #422857 is a reply to message #422237] Sun, 20 September 2009 19:32 Go to previous messageGo to next message
linlasj
Messages: 98
Registered: August 2005
Location: Linköping
Member
gurusuryas wrote on Tue, 15 September 2009 11:22

i could not move fields in corresponding place. please explain with one sample report if you can.

Please find the parts in the Oracle Reports docs on how to switch off flex and confine as you can read someone told you about in this thread.

the method to change an ordinary tabular report is, as said in this thread, to move fields around in the Paper Layout Editor. You can even do it carefully in the previewer. Why not give it a try in the preview. Just take a field and move it.

The basic reports made by the default things are not fun at all. You HAVE to move things around. And trust me, Oracle Reports is capable of very nice reports.

Report message to a moderator

Re: Issue in text formatting in oracle reports. [message #423677 is a reply to message #422857] Sat, 26 September 2009 06:16 Go to previous message
gurusuryas
Messages: 49
Registered: March 2009
Location: Chennai
Member
Hi to all,

Finally I got my customer's required Report Format through the help of this forum. Thanks to all,
especially to Littlefoot.

Thanks
Gurus

Report message to a moderator

Previous Topic: Sequential Numero per row in Report 10g
Next Topic: Oracle Reports Developer 10g Build Reports Ed 2 (Student Guide)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 22:24:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.