{"id":23796,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/column-reports-layouts-1\/"},"modified":"2024-02-15T14:53:34","modified_gmt":"2024-02-15T22:53:34","slug":"column-reports-layouts-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/column-reports-layouts-1\/","title":{"rendered":"Column Reports as Layouts"},"content":{"rendered":"<p>Column reports as layouts are prepared by first designing the column report. The column report is any column report that you create, with any filters.<\/p>\n<p>To prepare a Column layout report, choose the <b>Create layouts for existing reports<\/b> from the <b>Query \/ Report Options<\/b> list and press the <b>GO<\/b> button. After pressing the radio button <b>Column Report<\/b> at the top of the screen, you will see the following:<\/p>\n<p><img decoding=\"async\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/preparing_column_layout.png\" width=\"90%\" \/><\/p>\n<p><span class=\"imageCaption\">Preparing a column layout<\/span><\/p>\n<p>To prepare the report:<\/p>\n<p><img decoding=\"async\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/setting_style_PDF_report_3.png\" width=\"400\" \/><\/p>\n<p><span class=\"imageCaption\">Setting the style of an element on a PDF report<\/span><\/p>\n<ul>\n<li>\n\t\tYou are able to create complex, multi-line headers above the columns of data, using the capability in the <b>Optional Report Headers<\/b> section. You define the number of header rows, and then for each row you can define how many individual headers you require, and how many columns each of these will span. Please be careful to calculate these numbers accurately, as ExtraView does no checking and incorrect calculations will lead to strange-looking results. The diagram on the screen shows how the optional headers will appear.<\/li>\n<li>\n\t\tWhen you have completed the screen, <b>Save<\/b> the report. Note that you cannot run the report directly; it must first be placed in a container report before you can run it and output it to a PDF.<\/li>\n<\/ul>\n<h2>\n\tExample Column Layout<\/h2>\n<p>First create and save a column report. For our example, we created a Column report with several fields. Now we will place this report onto the layout:<\/p>\n<p><img decoding=\"async\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/sample_column_layout.png\" width=\"90%\" \/><\/p>\n<p><span class=\"imageCaption\">Sample Column Layout<\/span><\/p>\n<p>Note that we simply used the style buttons to embellish the column report output to the PDF. As a result, it looks like the following sample report.<\/p>\n<p><img decoding=\"async\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/sample_column_report.png\" width=\"90%\" \/><\/p>\n<p><span class=\"imageCaption\">Sample Column Report<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Column reports as layouts are prepared by first designing the column report. The column report is any column report that you create, with any filters. To prepare a Column layout report, choose the Create layouts for existing reports from the Query \/ Report Options list and press the GO button. After pressing the radio button&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-23796","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Column Reports as Layouts - Product Documentation<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.extraview.com\/v25\/column-reports-layouts-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Column Reports as Layouts - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"Column reports as layouts are prepared by first designing the column report. The column report is any column report that you create, with any filters. To prepare a Column layout report, choose the Create layouts for existing reports from the Query \/ Report Options list and press the GO button. After pressing the radio button...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/column-reports-layouts-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/column-reports-layouts-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/column-reports-layouts-1\/\",\"name\":\"Column Reports as Layouts - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/column-reports-layouts-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/column-reports-layouts-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/column-reports-layouts-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Column Reports as Layouts\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"name\":\"ExtraView Product Documentation\",\"description\":\"ExtraView Documentation\",\"publisher\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\",\"name\":\"ExtraView Corporation\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"contentUrl\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"ExtraView Corporation\"},\"image\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Column Reports as Layouts - Product Documentation","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.extraview.com\/v25\/column-reports-layouts-1\/","og_locale":"en_US","og_type":"article","og_title":"Column Reports as Layouts - Product Documentation","og_description":"Column reports as layouts are prepared by first designing the column report. The column report is any column report that you create, with any filters. To prepare a Column layout report, choose the Create layouts for existing reports from the Query \/ Report Options list and press the GO button. After pressing the radio button...","og_url":"https:\/\/docs.extraview.com\/v25\/column-reports-layouts-1\/","og_site_name":"Product Documentation","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v25\/column-reports-layouts-1\/","url":"https:\/\/docs.extraview.com\/v25\/column-reports-layouts-1\/","name":"Column Reports as Layouts - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/column-reports-layouts-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/column-reports-layouts-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/column-reports-layouts-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":2,"name":"Column Reports as Layouts"}]},{"@type":"WebSite","@id":"https:\/\/docs.extraview.com\/v25\/#website","url":"https:\/\/docs.extraview.com\/v25\/","name":"ExtraView Product Documentation","description":"ExtraView Documentation","publisher":{"@id":"https:\/\/docs.extraview.com\/v25\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.extraview.com\/v25\/#organization","name":"ExtraView Corporation","url":"https:\/\/docs.extraview.com\/v25\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/","url":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","contentUrl":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","width":512,"height":512,"caption":"ExtraView Corporation"},"image":{"@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/"}}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"carl.koppel","author_link":"https:\/\/docs.extraview.com\/v25\/author\/carl-koppel\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23796","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/comments?post=23796"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23796\/revisions"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=23796"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}