OraFAQ Forum: Reports & Discoverer » Oracle Report issue

Home » Developer & Programmer » Reports & Discoverer » Oracle Report issue

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

Oracle Report issue [message #616495]

Tue, 17 June 2014 09:37

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

i want to print the srno field instead of numeric number print the a,for 1 b for 2 and so on how i can do it.
second problem is i have the student report which have two block one is student boidata and the other is detail about the student qualification,sport etc now i want to print each student from starter.means if one student data is print upto 2 and half page the data of second student should start from begin of next page not from midle of second page ...

Report message to a moderator

Re: Oracle Report issue [message #616507 is a reply to message #616495]

Tue, 17 June 2014 14:15

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

waiting for reply...

Report message to a moderator

Re: Oracle Report issue [message #616509 is a reply to message #616507]

Tue, 17 June 2014 14:23

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

Senior Member
Account Moderator

Being impatient, are we? You should have already learnt (as you are member of this forum for 5 years) that we are all volunteers here who answer questions when we have some free time to spare and knowledge to provide answers. Nobody is waiting for your (or anyone else's) questions, and you can only HOPE that your questions will be answered. Therefore, don't hold your breath and don't push your luck.

As of your problems: (first things first)
- instead of 1 you want to display A
- instead of 2 you want to display B
- etc.
What do you want to display instead of 57? Instead of 3570?

The second problem: check what "Page protect" and "Page break before/after" frames' properties do. The simplest way is to run the report, observe the output, select repeating frame, push F4 (to open Property Palette window) and modify properties I specified. Check how the layout changes as you change their values. My first bet is to set the "Page protect" to YES.

Report message to a moderator

Re: Oracle Report issue [message #616528 is a reply to message #616509]

Tue, 17 June 2014 20:46

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

sir i have little value upto 15 or 16 srno i have to print.

Report message to a moderator

Re: Oracle Report issue [message #616534 is a reply to message #616528]

Wed, 18 June 2014 01:18

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

Senior Member
Account Moderator

Then it is rather easy:

select chr(64 + srno) letter_instead_of_number
from your_table

Report message to a moderator

Previous Topic:	Page Break Qtn. - pls. help..
Next Topic:	date format

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 22:40:59 CST 2025