Home » Developer & Programmer » Reports & Discoverer » Page breaks in Oracle Forms 6i
Page breaks in Oracle Forms 6i [message #90158] Thu, 18 November 2004 09:52 Go to next message
Heidi
Messages: 37
Registered: February 2000
Member
I have a report that is being printed to a PDF file.  In this example, the report has 3700+ records and has 7500+ pages.  I want the ability to print this report duplex, but if one record ends in an odd number, I want the next record to start on the next page, thus leaving a blank page.  For example, one record spans 3 pages, the 4th page (back side of 3rd page) should be blank and the next record start on it's own page.  Some records may only have 1 page while others may have 10+.  Any help is appreciated!
Re: Page breaks in Oracle Forms 6i [message #90209 is a reply to message #90158] Tue, 07 December 2004 15:44 Go to previous messageGo to next message
ap
Messages: 9
Registered: June 2003
Junior Member
I have the same requirement that you have. I was wondering if you have resolved this. I would really appreciate if you could help me.

Thanks,
Arshad
Re: Page breaks in Oracle Forms 6i [message #90211 is a reply to message #90209] Wed, 08 December 2004 07:36 Go to previous messageGo to next message
Heidi
Messages: 37
Registered: February 2000
Member
Not exactly. My project manager contacted Oracle for an answer. They directed her to someone who had the same question and whom they had sent an informational document to - kind of a long story. So my project manager contacted him. He responded that the document information actually caused more problems but in essence he said to do this:


1. Create a boilerplate object at the top of your main repeating group.
2. Turn on break before.
3. Add the following trigger to the object. (Modifying for your trigger name of course)

function B_1FormatTrigger return Boolean is

l_pagenumber number;
begin
srw.get_page_num(l_pagenumber);
if mod(l_pagenumber,2)=0 then
return(FALSE); -- Even numbered page
else
return(TRUE); --Odd numbered page
end if;
end;

I have not tried this as of yet, so I do not know if it will work or not.

If it does work for you or you use a part of it to work, please let me know.

Thanks,
Heidi
Re: Page breaks in Oracle Forms 6i [message #90212 is a reply to message #90211] Wed, 08 December 2004 13:00 Go to previous messageGo to next message
ap
Messages: 9
Registered: June 2003
Junior Member
Hi,

I have seen this over the metalink, and tried, this will not work. There are lots of notes available but none of them good. Basically most of the oracle technical consultant does search as we do and then copy from the existing notes and answer the question. "This is not good."

However today after spending 5 days, I have resolved this duplex (double-sided) issue.
The good thing in my solution there is no need to use the format trigger.

It is really tricky solution, but not difficult.
If you are still working and have not resolved then let me know your email.

Thanks,
Arshad Pervez
Re: Page breaks in Oracle Forms 6i [message #90213 is a reply to message #90212] Wed, 08 December 2004 13:34 Go to previous messageGo to next message
Heidi
Messages: 37
Registered: February 2000
Member
I would love to hear your solution. My email is crazyk9s@usa.net

Thanks,
Heidi
Re: Page breaks in Oracle Forms 6i [message #109123 is a reply to message #90212] Tue, 22 February 2005 01:03 Go to previous messageGo to next message
Mike Lane
Messages: 1
Registered: February 2005
Junior Member
Arshad,

I am also facing the need to print Duplex in Oracle reports. Can you also send me your solution to this problem?

Many thanks,
Mike
(mike.lane@unilog.co.uk)
Re: Page breaks in Oracle Forms 6i [message #116751 is a reply to message #109123] Thu, 21 April 2005 17:46 Go to previous messageGo to next message
mo_rios
Messages: 1
Registered: April 2005
Location: Bogota
Junior Member
Hi,

somebody can help me with the code for odd pages in duplex printer, i need it

Thanks


Monica Rios
mo_rios@hotmail.com
Re: Page breaks in Oracle Forms 6i [message #116855 is a reply to message #90158] Fri, 22 April 2005 09:29 Go to previous messageGo to next message
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
Senior Member
What was wrong with the Modular division approach? I tend to use this approach any time I need to alternate, for example, color schemes from one employee to another or something like that.

Just curious why the MOD division didn't work?

Regards,
Steve
Re: Page breaks in Oracle Forms 6i [message #119899 is a reply to message #90158] Mon, 16 May 2005 11:00 Go to previous messageGo to next message
shaji
Messages: 3
Registered: January 2002
Junior Member
can any send me the code,
i have the same problem.
my email is pshaji@yahoo.com
Re: Page breaks in Oracle Forms 6i [message #138938 is a reply to message #109123] Sun, 25 September 2005 22:30 Go to previous messageGo to next message
addatech
Messages: 1
Registered: September 2005
Junior Member
I'm not sure if any of you have received the sample code. I need it too.

It would be greatly appreciated if I could have the solution everyone seems to need.

Thanks in advance.

max@addatech.ca

[Updated on: Sun, 25 September 2005 22:30]

Report message to a moderator

Re: Page breaks in Oracle Forms 6i [message #139880 is a reply to message #90212] Thu, 29 September 2005 23:26 Go to previous messageGo to next message
agnesoo
Messages: 1
Registered: September 2005
Junior Member
Hi,

Could you mind to let me know the solution as well?
And my email is agnesoo@hotmail.com

Thanks Much!
Re: Page breaks in Oracle Forms 6i [message #147264 is a reply to message #90212] Wed, 16 November 2005 20:11 Go to previous messageGo to next message
tsiewwei78
Messages: 1
Registered: November 2005
Junior Member
Hi,

Currently I am doing an oracle report that need to have duplex printing. Can you please provide the solution that you found out?

Really appreciate if you can help on this.
Thanks a lot.

Regards,
siew wei
icon6.gif  Re: Page breaks in Oracle Forms 6i [message #148756 is a reply to message #147264] Sun, 27 November 2005 23:05 Go to previous messageGo to next message
adroit.ramesh
Messages: 14
Registered: November 2005
Junior Member
Help me out
i have the same problem
can any send me the code

my email is adroit.ramesh@gmail.com

Thanks in advance.
Re: Page breaks in Oracle Forms 6i [message #148878 is a reply to message #90211] Mon, 28 November 2005 16:50 Go to previous messageGo to next message
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
Senior Member
Heidi wrote on Wed, 08 December 2004 08:36

Not exactly. My project manager contacted Oracle for an answer. They directed her to someone who had the same question and whom they had sent an informational document to - kind of a long story. So my project manager contacted him. He responded that the document information actually caused more problems but in essence he said to do this:


1. Create a boilerplate object at the top of your main repeating group.
2. Turn on break before.
3. Add the following trigger to the object. (Modifying for your trigger name of course)

function B_1FormatTrigger return Boolean is

l_pagenumber number;
begin
srw.get_page_num(l_pagenumber);
if mod(l_pagenumber,2)=0 then
return(FALSE); -- Even numbered page
else
return(TRUE); --Odd numbered page
end if;
end;

I have not tried this as of yet, so I do not know if it will work or not.

If it does work for you or you use a part of it to work, please let me know.

Thanks,
Heidi


This should work. I questioned AP when he said it wouldn't. This is really only a partial solution, but the logic is sound. Re-reading Heidi's problem, I believe you need to actually use the MOD function against the row count of records. Dependant on how your query is grouped, the results could vary, but if you have no grouping, the MOD solution is fairly straightforward. The return of MOD will be either 0 or 1 if you use the '2' argument. That way, you can reference the value of the MOD function on the physical repeating frame in the report, instead of inserting boilerplate, which offers greater control to the developer (you) when creating the report.

HTH,
Steve

My mail is listed if you need further explanation, but please read up on the MOD function before emailing. Thanks!
Re: Page breaks in Oracle Forms 6i [message #183008 is a reply to message #90212] Wed, 19 July 2006 03:00 Go to previous messageGo to next message
ygm_ygm
Messages: 1
Registered: July 2006
Junior Member
am also doing an oracle report that needs to have duplex printing. Anyone with a solution please? My email is yotamug@zellco.co.zw
Re: Page breaks in Oracle Forms 6i [message #195834 is a reply to message #90212] Mon, 02 October 2006 13:06 Go to previous messageGo to next message
swatizalkikar
Messages: 1
Registered: October 2006
Junior Member
I am trying to build a duplex report. I will highly appreciate if you could send me the solution you have.
Thank You
swati@tampabay.rr.com

[Updated on: Mon, 02 October 2006 13:11]

Report message to a moderator

Re: Page breaks in Oracle Forms 6i [message #227772 is a reply to message #90158] Thu, 29 March 2007 06:35 Go to previous messageGo to next message
sim42
Messages: 1
Registered: March 2007
Junior Member
I am also trying to do duplex printing on report 3 and has not found the solution for over 2 weeks.
Can I have the solution please.
sim42@iinet.net.au
Re: Page breaks in Oracle Forms 6i [message #231390 is a reply to message #195834] Mon, 16 April 2007 22:17 Go to previous messageGo to next message
ersegur
Messages: 2
Registered: April 2007
Location: Peru
Junior Member

I am trying to build a duplex report. I will highly appreciate if you could send me the solution you have.

Thank You

esegura@rimac.com.pe
ersegur@gmail.com

[Updated on: Mon, 16 April 2007 22:20]

Report message to a moderator

Re: Page breaks in Oracle Forms 6i [message #231391 is a reply to message #90212] Mon, 16 April 2007 22:18 Go to previous messageGo to next message
ersegur
Messages: 2
Registered: April 2007
Location: Peru
Junior Member

I am trying to build a duplex report. I will highly appreciate if you could send me the solution you have.

Thank You
Re: Page breaks in Oracle Forms 6i [message #251375 is a reply to message #90212] Fri, 13 July 2007 06:51 Go to previous messageGo to next message
kentlai
Messages: 1
Registered: July 2007
Junior Member
I want to hear your solution. My email is kent.lai@yahoo.com.hk

Thanks,
Kent Lai
Re: Page breaks in Oracle Forms 6i [message #254553 is a reply to message #251375] Fri, 27 July 2007 02:05 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

plz send me solution at manizzzz@gmail.com
Re: Page breaks in Oracle Forms 6i [message #280174 is a reply to message #90158] Mon, 12 November 2007 12:54 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
Unless the code is huge, please post it in this thread. That way, everyone will not be forced to ask to have it sent.
Re: Page breaks in Oracle Forms 6i [message #299409 is a reply to message #90158] Mon, 11 February 2008 22:57 Go to previous messageGo to next message
ranjith_g99
Messages: 1
Registered: January 2007
Junior Member
please send me solution at ranjith_g99@hotmail.com
Re: Page breaks in Oracle Forms 6i [message #306348 is a reply to message #90212] Thu, 13 March 2008 16:58 Go to previous messageGo to next message
Me_11000
Messages: 1
Registered: March 2008
Location: burbank
Junior Member
Please email me the code


thanks,
Re: Page breaks in Oracle Forms 6i [message #306829 is a reply to message #90158] Mon, 17 March 2008 01:04 Go to previous messageGo to next message
irfan.ocp
Messages: 29
Registered: February 2008
Location: Karachi, Pakistan
Junior Member
Hi All,

Email me 2 on irfan.ocp@gmail.com

Waiting for you Solution Wink

Best Regards,
Muhammad Irfan Bakali.
Re: Page breaks in Oracle Forms 6i [message #326233 is a reply to message #90211] Tue, 10 June 2008 14:25 Go to previous messageGo to next message
kausar_iqbal
Messages: 1
Registered: November 2006
Location: Toronto
Junior Member
Hi All,
I want to send duplex printing option from form to report. Can you please help me in this regard.

My e-mail is: kausar_iqbal@hotmail.com

Thanks and Regards
Re: Page breaks in Oracle Forms 6i [message #326639 is a reply to message #90211] Thu, 12 June 2008 02:34 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Heidi wrote on Wed, 08 December 2004 13:36
Not exactly. My project manager contacted Oracle for an answer. They directed her to someone who had the same question and whom they had sent an informational document to - kind of a long story. So my project manager contacted him. He responded that the document information actually caused more problems but in essence he said to do this:


1. Create a boilerplate object at the top of your main repeating group.
2. Turn on break before.
3. Add the following trigger to the object. (Modifying for your trigger name of course)

function B_1FormatTrigger return Boolean is

l_pagenumber number;
begin
srw.get_page_num(l_pagenumber);
if mod(l_pagenumber,2)=0 then
return(FALSE); -- Even numbered page
else
return(TRUE); --Odd numbered page
end if;
end;

I have not tried this as of yet, so I do not know if it will work or not.

If it does work for you or you use a part of it to work, please let me know.

Thanks,
Heidi


Why don't you post it here so that everybody could benefit and the thread will not flooded with email adds.

[Updated on: Thu, 12 June 2008 02:37]

Report message to a moderator

Re: Page breaks in Oracle Forms 6i [message #334660 is a reply to message #90212] Thu, 17 July 2008 10:46 Go to previous messageGo to next message
dreeder
Messages: 1
Registered: July 2008
Location: UC Davis
Junior Member
I'd like the solution as well. Please email me at deb101958@yahoo.com

Thanks!
Re: Page breaks in Oracle Forms 6i [message #348138 is a reply to message #90158] Mon, 15 September 2008 14:44 Go to previous messageGo to next message
crazyjack
Messages: 1
Registered: March 2007
Junior Member
Hi All

Please email me the solution for duplex printing to crazyjackfromus@yahoo.com.

Thanks,
Richard
Re: Page breaks in Oracle Forms 6i [message #348140 is a reply to message #90158] Mon, 15 September 2008 14:47 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
The solution posted by Wency above worked fine for me.
Re: Page breaks in Oracle Forms 6i [message #349313 is a reply to message #90212] Sat, 20 September 2008 00:03 Go to previous messageGo to next message
subba99
Messages: 31
Registered: September 2008
Member
hi Arshad
please can u send me the code for to send duplex printing option from form to report. Can you please help me in this regard.


my mail id is subbu.alg@gmail.com
Re: Page breaks in Oracle Forms 6i [message #360974 is a reply to message #90212] Mon, 24 November 2008 08:51 Go to previous messageGo to next message
madhavimadan
Messages: 1
Registered: November 2008
Junior Member
I have the same problem.can any send me the code.
My email is madhavipuli@gmail.com

Thanks a lot.
Re: Page breaks in Oracle Forms 6i [message #361349 is a reply to message #348140] Wed, 26 November 2008 00:59 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Did I post the solution?
Re: Page breaks in Oracle Forms 6i [message #361355 is a reply to message #361349] Wed, 26 November 2008 01:12 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Yes, you have. It appears that people are satisfied with the way you have solved the problem.

However, as this topic turns into another "metoo" (check OraFAQ Forum Guide, All about braindumps section, background of the "dumps" and "metoo" topics), it is now locked.

If someone wants to continue discussion in a constructive manner, please, send me a private message (or just "report this message to a moderator"), explain what you'd like to do and it will be unlocked. For all of you who'd like to publish your e-mail here - ./fa/1579/0/
Previous Topic: get_application_property(username) in reports
Next Topic: create a graph or chart using report 6i
Goto Forum:
  


Current Time: Sat Dec 10 09:12:56 CST 2016

Total time taken to generate the page: 0.15609 seconds