1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

issue with pages in reports 10g

Discussion in 'Oracle Forms and Reports' started by nastyjillu, May 25, 2009.

  1. nastyjillu

    nastyjillu Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    hi iam new to this forum.i got an issue with reoprts 10g.

    i have 2 description fields fields in my report layout.

    desc_1 and desc_2.

    desc_2 is below desc_1.

    size of desc_1 is 2000 chars and size of desc_2 is 100 chars.

    now my problem is, if value in desc_1 is more then 1000 chars then iam getting error:
    TERMINATED_WITH_ERROR. and the error is

    REP-1814: Report cannot be formatted. Object 'vertically' can never fit within 'F_DESC_2'.

    what i understood is, if desc_1 is more then 1000 chars then the first page is not enough for the value in desc_1. then its pushing desc_2 in next page which is not hapenning and its throwing error.

    but the vertical elasticity is 'EXPAND' for both fields and their frames. and i tried giving print page to 'all pages' also.

    even though iam getting error.

    how to solve this??

    thanks
    jillu
     
  2. vamsioracle

    vamsioracle Forum Expert

    Messages:
    98
    Likes Received:
    1
    Trophy Points:
    140
    Hi jillu

    I once got the same problem but a bit different scenario.

    Try increasing the border and expand the filed length. It worked for me. If it is possible in your case try this



    vamsi
     
  3. nastyjillu

    nastyjillu Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    vamshi,

    do you want me to increase the border length in the layout??

    field length is 2000 chars. so it doent make difference.

    thanks
    jillu
     
  4. vamsioracle

    vamsioracle Forum Expert

    Messages:
    98
    Likes Received:
    1
    Trophy Points:
    140
    Yes

    Try increasing the border length in the layout and run the report.
     
  5. nastyjillu

    nastyjillu Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    vamsi,

    but if there are any problems with the border length, then i should have got error for all the inputs. but iam getting error only for inputs with dataype length>1000.
     
  6. ranjithkeral

    ranjithkeral Active Member

    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Gurgaon
    hi,

    It is not clear that how you fix all your frames and repeated frame.
    If you try to follow below steps then I think ur problem will get solved.

    first you place a frame let say f1 with property of

    vertical elasticity : variable


    place another frame inside f1 called f2 with property of

    vertical elasticity : variable

    place your desc1 field with property of

    vertical elasticity : variable in f2.

    Then place your second field below the f2 (that will be inside f1 frame)frame. It should work
     
  7. vamsioracle

    vamsioracle Forum Expert

    Messages:
    98
    Likes Received:
    1
    Trophy Points:
    140
    Yes,

    That was my intention actually. Since my report had a few elemnets, i increased the report border length. If not we can make that variable.

    Thanks a lot

    Vamsi