{"id":23795,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/double-group-layouts-1\/"},"modified":"2024-02-15T14:53:34","modified_gmt":"2024-02-15T22:53:34","slug":"double-group-layouts-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/double-group-layouts-1\/","title":{"rendered":"Double Group By Layouts"},"content":{"rendered":"<p>Double group by layouts are prepared by first designing a summary field, with two fields selected as the object of the summary list. For example, you may prepare a Summary report using the <b>Assigned to<\/b> and the <b>Product<\/b> fields. Any filters may be applied to this report.<\/p>\n<p>To prepare a Double Group By 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>Double Group By 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_double_group.png\" width=\"90%\" \/><\/p>\n<p><span class=\"imageCaption\">Preparing a double group by report<\/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_2.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\tThere are options in the form of checkboxes that allow you to suppress empty columns and empty rows on the report output<\/li>\n<li>\n\t\tNext there is an option that you can check to automatically compute totals for the report. If you turn this on, then totals for both the rows and the columns of the report will be generated<\/li>\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 Double Group By Report<\/h2>\n<p>First create and save a summary report. For our example, we create a Summary report with both <b>Assigned To<\/b> and <b>Status<\/b> selected. Now we will place this report onto the layout:<\/p>\n<p><img decoding=\"async\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/sample_double_group.png\" width=\"90%\" \/><\/p>\n<p><span class=\"imageCaption\">Sample Double Group By Report<\/span><\/p>\n<p>Notice how we supplied the report to run as <em>Assigned To by Status<\/em> as the report to group the results in a matrix form. If we add total, and some style information, then save the report, then include into a container report, and run the container report, we will see results similar to this:<\/p>\n<p><img decoding=\"async\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/sample_double_group_2.png\" width=\"90%\" \/><\/p>\n<p><span class=\"imageCaption\">Sample Double Group By Report<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Double group by layouts are prepared by first designing a summary field, with two fields selected as the object of the summary list. For example, you may prepare a Summary report using the Assigned to and the Product fields. Any filters may be applied to this report. To prepare a Double Group By layout report,&#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-23795","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>Double Group By 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\/double-group-layouts-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Double Group By Layouts - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"Double group by layouts are prepared by first designing a summary field, with two fields selected as the object of the summary list. For example, you may prepare a Summary report using the Assigned to and the Product fields. Any filters may be applied to this report. To prepare a Double Group By layout report,...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/double-group-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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/double-group-layouts-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/double-group-layouts-1\/\",\"name\":\"Double Group By 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\/double-group-layouts-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/double-group-layouts-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/double-group-layouts-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Double Group By 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":"Double Group By 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\/double-group-layouts-1\/","og_locale":"en_US","og_type":"article","og_title":"Double Group By Layouts - Product Documentation","og_description":"Double group by layouts are prepared by first designing a summary field, with two fields selected as the object of the summary list. For example, you may prepare a Summary report using the Assigned to and the Product fields. Any filters may be applied to this report. To prepare a Double Group By layout report,...","og_url":"https:\/\/docs.extraview.com\/v25\/double-group-layouts-1\/","og_site_name":"Product Documentation","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v25\/double-group-layouts-1\/","url":"https:\/\/docs.extraview.com\/v25\/double-group-layouts-1\/","name":"Double Group By 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\/double-group-layouts-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/double-group-layouts-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/double-group-layouts-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":2,"name":"Double Group By 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\/23795","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=23795"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23795\/revisions"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=23795"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}