{"id":176,"date":"2023-09-25T22:48:57","date_gmt":"2023-09-25T22:48:57","guid":{"rendered":"https:\/\/e360hospitality.com\/?p=176"},"modified":"2024-04-25T05:56:39","modified_gmt":"2024-04-25T05:56:39","slug":"rep-1814-the-report-cannot-be-formatted","status":"publish","type":"post","link":"https:\/\/e360hospitality.com\/opera-pms-technical\/rep-1814-the-report-cannot-be-formatted\/","title":{"rendered":"REP-1814: The report cannot be formatted."},"content":{"rendered":"\n

Oracle reports with multiple pages in the report designer.<\/h4>\n\n\n\n

Are you trying to format an Oracle Report for Opera<\/a>, and you get the above error?<\/p>\n\n\n\n

I got it too, and spent several hours finding a solution I am sharing below. In my case, I had to create a customer detail report where each customer record could span across two pages like the below image:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

I know what clicks in your mind.<\/p>\n\n\n\n

    \n
  • What if you keep a ‘Repeater’ on page 1 and then, keep another Repeater on page 2? The result is that only the first pages of each record finish printing first, then the second continues – This is not a solution!<\/li>\n\n\n\n
  • What if you insert a Repeater and expand that to cover both pages? You will get “REP-1814: The report cannot be formatted. Object vertically cannot fit within location<\/em><\/strong>” error.<\/li>\n<\/ul>\n\n\n\n
    \n
    \n
    \n
    \n
    \n
    \n

    <\/p>\n<\/blockquote>\n<\/blockquote>\n<\/blockquote>\n<\/blockquote>\n<\/blockquote>\n<\/blockquote>\n\n\n\n

    REP-1814 is resolved like below<\/strong><\/h3>\n\n\n\n

    There is a concept of ‘physical page and logical page’. In the report design, you have the page where you put in the fields – this is your physical page. If a single record, like in my example, each customer record needs two physical pages to contain all required details, I need to have two physical pages in the report design as in the above image. <\/p>\n\n\n\n

    Then, you need to tell Oracle Reports that these two physical pages work as ‘one Logial page’ for the report to work as intended.<\/p>\n\n\n\n

    Here are the steps:<\/strong><\/p>\n\n\n\n

      \n
    1. Design the required layout with two physical pages.<\/li>\n\n\n\n
    2. Only use a single main ‘Repeater’ that covers the contents of physical page 1 & physical page 2.<\/li>\n\n\n\n
    3. Expand your report tree, go to ‘Main Section’, and right-click to select ‘Property Inspector’.<\/li>\n\n\n\n
    4. Here, ensure that ‘Vertical Panels per Page’ is set to 2.<\/li>\n<\/ol>\n\n\n\n
      \"rep-1814\"<\/figure>\n\n\n\n

      <\/p>\n\n\n\n

      You’re now ready to test your report.<\/p>\n","protected":false},"excerpt":{"rendered":"

      Oracle reports with multiple pages in the report designer. Are you trying to format an Oracle Report for Opera, and you get the above error? I got it too, and [\u2026]<\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","om_disable_all_campaigns":false,"ub_ctt_via":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[24],"tags":[19,18,20],"aioseo_notices":[],"featured_image_src":null,"author_info":{"display_name":"Staff Writer","author_link":"https:\/\/e360hospitality.com\/author\/staff-writer\/"},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","wps_subtitle":"","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/posts\/176"}],"collection":[{"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/comments?post=176"}],"version-history":[{"count":4,"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/posts\/176\/revisions"}],"predecessor-version":[{"id":1505,"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/posts\/176\/revisions\/1505"}],"wp:attachment":[{"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/media?parent=176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/categories?post=176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/e360hospitality.com\/wp-json\/wp\/v2\/tags?post=176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}