Home » Developer & Programmer » Reports & Discoverer » Space issue in the oracle report output (Report Builder 6i)
Space issue in the oracle report output [message #580619] Tue, 26 March 2013 04:26 Go to next message
Anand Mallarapu
Messages: 12
Registered: March 2013
Location: India
Junior Member
I have one issue with spacing in the report output layout.

l_micr_string := '/'||to_char(:C_CHECK_NUMBER)||'/&'||:C_ROUTING_NUM||'& '||
substr(:C_BANK_ACCOUNT_NUM_ON_US,1,2)||
substr(:C_BANK_ACCOUNT_NUM_ON_US,3,length(:C_BANK_ACCOUNT_NUM_ON_US))||'/';


This report output is the print the check number.Generally we will have check and some other number in the down of the check. Like |'142456'| |:12345678:| 123456|'

The above code will print the check number. Now i wanted to move the check number one cell left side, so i changed the layout one cell left side but it is not working.

Could any one help on this and explain the code('/' and '/& ') what it indicates.

Re: Space issue in the oracle report output [message #580620 is a reply to message #580619] Tue, 26 March 2013 04:56 Go to previous messageGo to next message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
SQL> select  '/'||to_char('1223')||'/&'||'4567'||'& '||
  2  substr('sriram',1,2)||
  3  substr('sriram',3,length('sriram'))||'/'  your_result from dual
  4  /

YOUR_RESULT
--------------------
/1223/&4567& sriram/


Quote:
Could any one help on this and explain the code('/' and '/& ') what it indicates.


Those are nothing but string which will be printed on Output.

For more detailed answer please post the test case with what exactly your are looking for !

Sriram Sanka
Re: Space issue in the oracle report output [message #580624 is a reply to message #580619] Tue, 26 March 2013 05:05 Go to previous messageGo to next message
Anand Mallarapu
Messages: 12
Registered: March 2013
Location: India
Junior Member
Thanks for information.
If you look at the attached screen short, i wanted move that entire check number with one character left side.

./fa/10704/0/


[EDITED by LF: inserted image into the body]

[Updated on: Tue, 26 March 2013 05:11] by Moderator

Report message to a moderator

Re: Space issue in the oracle report output [message #580625 is a reply to message #580624] Tue, 26 March 2013 05:07 Go to previous messageGo to next message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
I Can`t download any files from Internet, why don`t you copy and paste your requirement!

Thanks
Sriram Sanka
Re: Space issue in the oracle report output [message #580626 is a reply to message #580625] Tue, 26 March 2013 05:13 Go to previous messageGo to next message
Anand Mallarapu
Messages: 12
Registered: March 2013
Location: India
Junior Member
I am not able paste that picture here. [img]C:\Documents and Settings\anand.mallarapu\Desktop\format issue.JPEG[/img] .
Re: Space issue in the oracle report output [message #580627 is a reply to message #580625] Tue, 26 March 2013 05:13 Go to previous messageGo to next message
Littlefoot
Messages: 19314
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How does the paper layout look like? Is check number a separate field, or do you print the whole row into a single field?
Re: Space issue in the oracle report output [message #580628 is a reply to message #580627] Tue, 26 March 2013 05:18 Go to previous messageGo to next message
Anand Mallarapu
Messages: 12
Registered: March 2013
Location: India
Junior Member
My requirement is Like |'142456'| |:12345678:| 123456|'

This is check number, if you look at normal check it will print in the middle of the bottom. But customer want to just move this number one cell left side.

The entire number into a single row only.
Re: Space issue in the oracle report output [message #580629 is a reply to message #580628] Tue, 26 March 2013 05:30 Go to previous messageGo to next message
Littlefoot
Messages: 19314
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I can't look at a"normal check" because - I don't have any.

Why can't you move the field one character to the left? Did you hit the margin? If so, go to margin editor and stretch it to the left; then, I hope, you'll be able to do that.
Re: Space issue in the oracle report output [message #580631 is a reply to message #580629] Tue, 26 March 2013 05:35 Go to previous messageGo to next message
Anand Mallarapu
Messages: 12
Registered: March 2013
Location: India
Junior Member
Ya i tried changing the layout bit left side but it didn't work. Can you able to read my above posts because i have posted my sample print. Which explains clearly. If you cant read i will attach it for you one more time.
Re: Space issue in the oracle report output [message #580633 is a reply to message #580631] Tue, 26 March 2013 05:54 Go to previous messageGo to next message
Littlefoot
Messages: 19314
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No problem on my side, I saw everything you said, as well as FORMAT_ISSUE.JPG.

Could you post a screenshot of Paper Layout Editor as well?
Re: Space issue in the oracle report output [message #580635 is a reply to message #580633] Tue, 26 March 2013 06:13 Go to previous messageGo to next message
Anand Mallarapu
Messages: 12
Registered: March 2013
Location: India
Junior Member
I have posted the layout as well.

If you look at the attachment top one is printing the check number. Mean while i wanted to know what printer code after and before will indicate in the property palette. Because they have written printer code before as "&100" and printer code before as "&103".

./fa/10705/0/


[EDITED by LF: inserted image into the body]
  • Attachment: layout.JPG
    (Size: 87.48KB, Downloaded 138 times)

[Updated on: Tue, 26 March 2013 06:48] by Moderator

Report message to a moderator

Re: Space issue in the oracle report output [message #580637 is a reply to message #580635] Tue, 26 March 2013 06:37 Go to previous messageGo to next message
Littlefoot
Messages: 19314
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Right; layout is here, but - what field represents check number?

As of printer codes: no idea, sorry, I never used them.
Re: Space issue in the oracle report output [message #580638 is a reply to message #580637] Tue, 26 March 2013 06:43 Go to previous messageGo to next message
Anand Mallarapu
Messages: 12
Registered: March 2013
Location: India
Junior Member
F_MIC first field will indicate the check number.
Re: Space issue in the oracle report output [message #580640 is a reply to message #580638] Tue, 26 March 2013 06:50 Go to previous message
Littlefoot
Messages: 19314
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Hm, there's enough place to move it left ... you said (in your first message) that you did that, but nothing happened, right? What happens if you anchor left side of that "check number" frame with a large frame below it?
Previous Topic: Integrate Google Maps in OBIEE11g
Next Topic: Error in report
Goto Forum:
  


Current Time: Fri Jul 25 13:57:24 CDT 2014

Total time taken to generate the page: 0.13407 seconds