Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

EBS bi publisher no of lines issue

Received Response
293
Views
18
Comments

Summary

EBS bi publisher no of lines issue

Content

Hi All,

 

​I have lpp=14 line per page​

 

For your reference.

 

1st page

 

Header with 6 lines printing

 

2nd page

 

It is not printing 14 lines page even  though if i have space on the 2nd page see the below

 

image

 

and printing remaining lines on the 3rd page.

​ ​ Could you please add me as a friend just now i sent you.

 

 

Could you please help me on this?

Tagged:
«1

Answers

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    For one of my requirement where in each page i need to print 30 lines and 31 line should go to next page I achieved below

    Below are the sample rtf with start body and end body, row which I highlighted in Yellow are just blank row to restrict body space to print only 30 lines(Because of preprinted paper size)

    image

    Sample Output

    image

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Can you try without lpp 14 and just control through footer space?

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    you can control the number of lines per page by setting your footer space e.g. suppose you want to print 14 lines per page  then

    <?start:body?>

    <?end body?>

      <This is footer section , hear add as many as blank/hidden tables rows so that you left 1 lines space for body>

    Once we set the footer in this way doesn't matter number of lines in first page or rest of the pages. if its less than 14 it will print in first page if more than 14 it will automatically go to next page

  • Rajesh123
    Rajesh123 Rank 6 - Analytics Lead

    Yes you are correct, but the last line of first page data is going to printing on 2nd page.

  • Rajesh123
    Rajesh123 Rank 6 - Analytics Lead

    Thank you Rajesh.

    Do you me to remove lpp=14 line and add the syntax which was provided you?

    I have tried with lpp=14 and start and end body , but no luck

  • Rajesh123
    Rajesh123 Rank 6 - Analytics Lead

    see the below screen.

    It is printing previous page last line row which is not good (look & feel), so that is why i was used print no of lines per page syntax.

    image

    But my bad luck it was not in correct behavior, i have sent you the email with details , could you please help me on this?

  • Rajesh123
    Rajesh123 Rank 6 - Analytics Lead
    Brajesh Shukla wrote:Hi Rajesh,I have seen your rtf and I think PB with below condition is causing the issue. May I know what exactly this page break is for? in this $start is not getting proper value <xsl:if xdofo:ctx="inblock" test="$start+$lpp<=count($invLines)"><xsl:attribute name="break-before">page</xsl:attribute></xsl:if>

    if the specified number of rows has been met then insert a page break.

    I have used https://blogs.oracle.com/xmlpublisher/anatomy-of-a-template-i-fixed-row-enumeration  link.

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    but the last line of first page data is going to printing on 2nd page.   : What it means? can you give example

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Can you uncheck the option  Allow row to break across the pages

    image

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Hi Rajesh,

    I have seen your rtf and I think PB with below condition is causing the issue. May I know what exactly this page  break is for? in this $start is not getting proper value

    <xsl:if xdofo:ctx="inblock" test="$start+$lpp<=count($invLines)"><xsl:attribute name="break-before">page</xsl:attribute></xsl:if>