OraFAQ Forum: Reports & Discoverer » Space issue in the oracle report output

Home » Developer & Programmer » Reports & Discoverer » Space issue in the oracle report output (Report Builder 6i)

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

Space issue in the oracle report output [message #580619]

Tue, 26 March 2013 04:26

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.

Report message to a moderator

Re: Space issue in the oracle report output [message #580620 is a reply to message #580619]

Tue, 26 March 2013 04:56

ramoradba
Messages: 2457
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

Report message to a moderator

Re: Space issue in the oracle report output [message #580624 is a reply to message #580619]

Tue, 26 March 2013 05:05

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.

/forum/fa/10704/0/

[EDITED by LF: inserted image into the body]

Attachment: format issue.jpg
(Size: 109.41KB, Downloaded 2497 times)

[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

ramoradba
Messages: 2457
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

Report message to a moderator

Re: Space issue in the oracle report output [message #580626 is a reply to message #580625]

Tue, 26 March 2013 05:13

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] .

Report message to a moderator

Re: Space issue in the oracle report output [message #580627 is a reply to message #580625]

Tue, 26 March 2013 05:13

Littlefoot
Messages: 21823
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?

Report message to a moderator

Re: Space issue in the oracle report output [message #580628 is a reply to message #580627]

Tue, 26 March 2013 05:18

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.

Report message to a moderator

Re: Space issue in the oracle report output [message #580629 is a reply to message #580628]

Tue, 26 March 2013 05:30

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Space issue in the oracle report output [message #580631 is a reply to message #580629]

Tue, 26 March 2013 05:35

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.

Report message to a moderator

Re: Space issue in the oracle report output [message #580633 is a reply to message #580631]

Tue, 26 March 2013 05:54

Littlefoot
Messages: 21823
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?

Report message to a moderator

Re: Space issue in the oracle report output [message #580635 is a reply to message #580633]

Tue, 26 March 2013 06:13

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".

/forum/fa/10705/0/

[EDITED by LF: inserted image into the body]

Attachment: layout.JPG
(Size: 87.48KB, Downloaded 2371 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

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Space issue in the oracle report output [message #580638 is a reply to message #580637]

Tue, 26 March 2013 06:43

Anand Mallarapu
Messages: 12
Registered: March 2013
Location: India

Junior Member

F_MIC first field will indicate the check number.

Report message to a moderator

Re: Space issue in the oracle report output [message #580640 is a reply to message #580638]

Tue, 26 March 2013 06:50

Littlefoot
Messages: 21823
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?

Report message to a moderator

Previous Topic:	Integrate Google Maps in OBIEE11g
Next Topic:	Error in report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 23:36:24 CST 2024