Skip to Content
author's profile photo Former Member
Former Member

breaking he rows

hi

i created a sale quotation using print layout design.

when i select 3 items its showing all in a single page

when i select 5 items its showing 4 in one page and after repetitive area it is leaving all space and printing 5th one in next page in the same way if i select 6 items it displays 5 in one page another one in next page leaving lot of empty space in the 1 st page.

thanks in advance

regards

praveen

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 07:06 AM

    Hi

    Check print preferences under System Initialization>max rows. If that's ok then check if Repetitive Area properties > Format tab > lines in repetitive area isn't putting a restriction on the no of lines.

    Daan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 07:29 AM

    When in print layout design - highlight repetitive area in field index window. That will display the properties in the window directly below the field index window. Click on format tab.

    You should also make sure that there is enough space on you layout to display the required no of rows. That is, if the other areas like header, start of report, end of report etc, takes up too much space, your print can't display enough rows. Tick the area height adjustment box in the format tabs of the areas (properties).

    Daan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      hi

      i have posted to sap and i have got some work arounds and i could solve the problem you can see the explanation below.

      As repetitive area captures all the rows present in the document

      per row(item wise) so as per our conversation these are the two

      workaround I can recommend:

      1---Add a formula field_A under repetitive are:

      +Formula:LineNum()

      Add a formula field under repetitive are:

      +Formula:field_A=='(the line number you want to get from rows of item)'

      2----Sort the repetive area with Sales Order-Item No,check the box

      New Page,this will lead to get seperate items in seperate pages

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 08:53 AM

    Hi

    The only other problem then will be that the other areas in the report (header etc) are taking up too much space. You will have too adjust the fields to be closer too each other and eliminate unused space as much as possible.

    I suggest you save your layout under a new name and as a test delete some fields in the header of this new layout, and make it half the size it is now. Make this the default layout and test the print. If it prints more rows, you know lack of space is the problem.

    You can always revert to the current layout.

    Daan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 07:08 AM

    Hi praveen,

    Solution of your query is all "end of report" area transfer in "repetitive area footer"

    then chek your problem resolve or not.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.