Home » Developer & Programmer » Reports & Discoverer » Oracle Report issue
Oracle Report issue [message #616495] Tue, 17 June 2014 09:37 Go to next message
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 ...
Re: Oracle Report issue [message #616507 is a reply to message #616495] Tue, 17 June 2014 14:15 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan
Senior Member

waiting for reply...
Re: Oracle Report issue [message #616509 is a reply to message #616507] Tue, 17 June 2014 14:23 Go to previous messageGo to next message
Littlefoot
Messages: 21509
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.
Re: Oracle Report issue [message #616528 is a reply to message #616509] Tue, 17 June 2014 20:46 Go to previous messageGo to next message
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.
Re: Oracle Report issue [message #616534 is a reply to message #616528] Wed, 18 June 2014 01:18 Go to previous message
Littlefoot
Messages: 21509
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
Previous Topic: Page Break Qtn. - pls. help..
Next Topic: date format
Goto Forum:
  


Current Time: Sat Nov 16 17:46:44 CST 2019