X

An Oracle blog about BI Publisher

  • RTF
    July 7, 2008

Conditional Page Breaking

Quick tidbit today from Hok Min, the new RTF uber meister. It came out of a question with someone trying to use the 'split-by-page-break' command in a bit of a funky way. They had the following code:
<?if:CF_LPN_FLAG='Y'?>
<?split-by-page-break: ?>
<?end if?>

Its a nice enhancement candidate but its not going to work. We are expecting the split-by-page-break command inside a loop not as part of a condition.
Say, you're looping over departments (DEPT) and want a page break when the department changes. You'd have something like
<?for-each:DEPT?>
...
...
...
<?split-by-page-break:?>
<?end for-each?>

This would get out engine to insert a page break into the document before the occurrence of a new department.
To get the original code above to work you physically need to insert a page break into your template. Kinda screws the WYSIWYG layout a bit but you get the desired functionality i.e. a conditional page break.
For a sample RTF and XML click here

Join the discussion

Comments ( 15 )
  • Sonali Wednesday, October 22, 2008
    I am trying to do a simple page break
    I have a vendor group and list of POs for each
    After each vendor I need a page break. I tried
    It does not work every time
    Not sure why
  • Toloson Saturday, June 20, 2009
    lets you do exactlyto dial up any ofanyone sincerely
    tarot card meaningsencyclopedia ofessence, Tarot.comTarot reading by[url=http://gitarista.sk/board/member.php?u=46359]free tarot reading on love[/url]scholar and a bishopsimply not availabletechnology, it
  • JimO Thursday, June 25, 2009
    Hi,
    I hope that I have a simple question for you. I have a rtf template that I am applying on top of a seeded Oracle Applications report (rdf). The users have requested that I put a page break on a column. I know that it would be easy if I could change the rdf, but I want to keep that unchanged for support reasons. How can I create a page break based on a value of one of the fields?
    So my xml looks like this:

    <INVTOPKL>
       <LIST_G_PICK_SLIP_NUMBER>
          <G_PICK_SLIP_NUMBER>
             <PICK_SLIP_NUMBER>476715</PICK_SLIP_NUMBER>
             <LIST_G_PARENT_LINE_ID>
                <G_PARENT_LINE_ID>
                   <PARENT_LINE_ID></PARENT_LINE_ID>
                   <LIST_G_MAIN_GROUP>
                      <G_MAIN_GROUP>
                         <SUB_DROPPING_ORDER></SUB_DROPPING_ORDER>
                         <LOC_DROPPING_ORDER></LOC_DROPPING_ORDER>
                         <REQUEST_NUMBER>400450</REQUEST_NUMBER>
                         <MOVE_ORDER_TYPE>5</MOVE_ORDER_TYPE>
                         <LINE_NUMBER>1</LINE_NUMBER>
                      </G_MAIN_GROUP>
                      <G_MAIN_GROUP>
                         <SUB_DROPPING_ORDER></SUB_DROPPING_ORDER>
                         <LOC_DROPPING_ORDER></LOC_DROPPING_ORDER>
                         <REQUEST_NUMBER>400450</REQUEST_NUMBER>
                         <MOVE_ORDER_TYPE>5</MOVE_ORDER_TYPE>
                         <LINE_NUMBER>3</LINE_NUMBER>
                      </G_MAIN_GROUP>
                      <G_MAIN_GROUP>
                         <SUB_DROPPING_ORDER></SUB_DROPPING_ORDER>
                         <LOC_DROPPING_ORDER></LOC_DROPPING_ORDER>
                         <REQUEST_NUMBER>400451</REQUEST_NUMBER>
                         <MOVE_ORDER_TYPE>5</MOVE_ORDER_TYPE>
                         <LINE_NUMBER>4</LINE_NUMBER>
                      </G_MAIN_GROUP>

    ...
                   </LIST_G_MAIN_GROUP>
                   <LIST_G_PARENT_LINE>
                   </LIST_G_PARENT_LINE>
                </G_PARENT_LINE_ID>
             </LIST_G_PARENT_LINE_ID>
          </G_PICK_SLIP_NUMBER>
       </LIST_G_PICK_SLIP_NUMBER>
    </INVTOPKL>

    Currently, the rtf template has a for-each on <G_MAIN_GROUP>. I would like it to page beak whenever the <REQUEST_NUMBER> changes (it is already sorted this way). Is this possible?
    Thanks,
  • Sumeth Friday, August 14, 2009
    Thank you very much
  • vijay Monday, November 2, 2009
    I have something simple question like Sonali. I have data generated by PL/SQL procedure, here is sample of complete set of data.



    286101
    SOFTWARE
    COMPUTER
    Tax Expense Reversal created by tax link
    850806
    VCP IT Powered
    15-AUG-08
    0
    -67.41
    -67.41


    I have inserted grouping in my rtf template for each facility and then cat_major. I need page break once facility change.
    I tried split-by-page-break and page-break="yes" in various field in field property (Add help Text...) at beginning and end of group but, it does not help.
    Any suggestions?
    Vijay
  • free physic Friday, March 19, 2010
    Ok, I am contemplating doing something I have never done before out of my relentlessly anxious curiosity about my near future. I am considering getting a psychic reading done--either over the telephone or in person but there are so many frauds out there claiming to be a genuine medium with profoundly right and true guidance/answers that I wouldn't know the very small amount of mediums who are actually sincerely psychic from the many who are just phonies looking for money. If you personally have had an exceptionally 'true' psychic reading done that has proved since then to be pretty darn accurate considering what has happened in your life since your psychic 'reading' NOT a palm reading or tarot card reading please (as I've tried both of those more than once and they were all horribly inaccurate so for obvious reasons I do not wish to get another tarot or palm 'readings' ) so, if you have had a startlingly accurate psychic reading could you please recommend to me the person who did it and how i could get in contact with him or her. I live near Syracuse, NY but as I mentioned I would be willing to have this psychic reading done online or on the telephone if necessary. I really want something to believe in, please let me know, many genuine thanks!
  • rajeshkhatri Tuesday, April 6, 2010
    Hi,
    I have 4 groups : g_due_date, g_supplier, g_item, g_Details.
    My requirement is if g_due_date and g_supplier should not print not print alone on a page. It should print only if there is space for g_item to print. How can I achieve this.
  • Joelle Neumiller Thursday, April 8, 2010
    Having completed a search for psychic mediums on Yahoo I came across your site, and am I glad I did. I am impressed with the quality of info I have obtained here, and I am sure that this will be not merely helpful to me but to others also. I have appended you to my list of favourite blogs and will be back on a regular basic
  • Alden Mesker Monday, April 12, 2010
    Thankfully, whilst I was researching aol I came across your super site. I must say the content and info here is first class, and will be very helpful to me and I suspect others. To make sure I call back on a regular basis I have appended the web site to my favourites.
  • MaorPB Tuesday, June 22, 2010
    I have a litle different problem:
    I'm designing a RTF file in MSWORD.
    In my file I'm using a section of multicolumn text. This section is printed upon a condition that should be met. However, when that condition is not met, and The BIP generates the PDF file, it converts the section break to a page break, hence inserting a blank page at the end of my PDF.
    I have tried to bypass the problem by setting the printing condition before the section break, but then the BIP seems to move the section out of the IF scope(I also saw it in the XSL-FO structure). It simply ignores the condition.
    Can anyone help me with this?
  • Second chance romance Tuesday, September 21, 2010
    Thank you for a great post
  • Tarot reading Thursday, September 23, 2010
    Excellent job.
  • guest Sunday, October 2, 2011

    how can use @section,what is the difference between @section and split by pagabreak.Please advice me

    Thanks

    Bhaskar.B


  • guest Friday, May 22, 2015

    If you create a template called PB at the bottom of your rtf document then call the template from inside your if:end if code then you won't lose your WYSIWYG layout very much.


  • guest Friday, August 28, 2015

    Hi,

    I am trying to do a split-by-page-break but i am inside a group by. The goal is to only get a certain number of rows per page. No matter what i have tried it will not execute the split-by-page-break.

    Thanks,

    Greg


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.