{"id":23794,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/single-group-layouts-1\/"},"modified":"2024-02-15T14:53:34","modified_gmt":"2024-02-15T22:53:34","slug":"single-group-layouts-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/single-group-layouts-1\/","title":{"rendered":"Single Group By Layouts"},"content":{"rendered":"<p>Single group by layouts are prepared by first designing one or more Summary reports, <b>each with a single field<\/b> as the object of the summary list. For example, you may prepare a Summary report using the <b>product_name<\/b> or the <b>area<\/b> field. Any filters may be applied to each of the reports.<\/p>\n<p>Further, each of the summary reports may use a different field as its object. This will allow you to prepare a layout where each row or column of the layout represents a totally different variable being counted. Thus you can have different rows or different columns represent different information on a single report.<\/p>\n<p>To prepare a Single Group By layout report, choose the <b>Create layouts for existing reports<\/b> from the <b>Query \/ Report Options<b> <\/b><\/b>list and press the <strong>GO <\/strong>button. You will see the following screen:<\/p>\n<p><b><b><img decoding=\"async\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/preparing_single_group_report.png\" width=\"90%\" \/> <\/b><\/b><\/p>\n<p><span class=\"imageCaption\">Preparing a single group by report<\/span><\/p>\n<p>Note that the radio button selection at the top of the screen already reflects your choice of the Single Group By report. To prepare the report:<\/p>\n<ul>\n<li>\n\t\tDecide whether the titles for each Summary report that is to be rendered are to be in the columns or rows of the report. Notice that the image that portrays the style of the report changes to represent your choice<\/li>\n<li>\n\t\tWithin the field <strong>Select query field to group by<\/strong>, you will see a list of all the Summary reports that are possible to select. These will all be Summary reports that have a single field selected for the summary. These reports must all exist before you create the layout<\/li>\n<li>\n\t\tEnter the text for the report header and for the legend to appear under the header<\/li>\n<li>\n\t\tFor each of the report header, the legend, the column header and the data display, you can set the style of the output by using the <img decoding=\"async\" src=\"\/v25\/extraview-media\/images\/ag\/initial_setup\/Style.gif\" style=\"display:inline\" \/> button. When you hold your mouse over the button, you will see a summary of the style that is set. When you click on this button, you will see a pop up window where you can set the style<\/p>\n<p>\t\t<img decoding=\"async\" alt=\"\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/setting_style_PDF_report.png\" style=\"width: 50%;\" \/><\/li>\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 are rendering titles in Columns, then you will get column totals, if you are rendering the output in Rows, then you will get row totals on the output<\/li>\n<li>\n\t\tNext, you set the number of queries you want on your report. For each query, you will have a selection list from which to select the reports. Then you select the reports, and you select the title to display for each of the reports<\/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<h3>\n\tExample Single Group By Report<\/h3>\n<p>First create and save three summary reports. Each of these has the <b>product_name<\/b> field (titled <b>Product<\/b>) as the selected field. For each of the three reports, select a single filter, as follows for each report:<\/p>\n<ul>\n<li>\n\t\tStatus = Open<\/li>\n<li>\n\t\tStatus = Fixed<\/li>\n<li>\n\t\tStatus = Closed<\/li>\n<\/ul>\n<p>You will now have three summary reports titled something like:<\/p>\n<ul>\n<li>\n\t\tSummary of Open Customer Issues<\/li>\n<li>\n\t\tSummary of Fixed Customer Issues<\/li>\n<li>\n\t\tSummary of Closed Customer Issues<\/li>\n<\/ul>\n<p>Now we will place these fields onto the layout:<\/p>\n<p><img decoding=\"async\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/sample_single_group_report.png\" width=\"90%\" \/><\/p>\n<p><span class=\"imageCaption\">Sample Single Group By Report<\/span><\/p>\n<p>Notice how we supplied the field to group by as <b>Product<\/b> and then set up three queries to include. Of course, these are the three summary reports we set up earlier in the example. For this example, we also set up some additional header rows as shown on the screenshots. If we save this, 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_single_group_report_2.png\" width=\"90%\" \/><\/p>\n<p><span class=\"imageCaption\">Sample Single Group By Report<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Single group by layouts are prepared by first designing one or more Summary reports, each with a single field as the object of the summary list. For example, you may prepare a Summary report using the product_name or the area field. Any filters may be applied to each of the reports. Further, each of the&#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-23794","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>Single 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\/single-group-layouts-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Single Group By Layouts - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"Single group by layouts are prepared by first designing one or more Summary reports, each with a single field as the object of the summary list. For example, you may prepare a Summary report using the product_name or the area field. Any filters may be applied to each of the reports. Further, each of the...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/single-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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/single-group-layouts-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/single-group-layouts-1\/\",\"name\":\"Single 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\/single-group-layouts-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/single-group-layouts-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/single-group-layouts-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Single 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":"Single 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\/single-group-layouts-1\/","og_locale":"en_US","og_type":"article","og_title":"Single Group By Layouts - Product Documentation","og_description":"Single group by layouts are prepared by first designing one or more Summary reports, each with a single field as the object of the summary list. For example, you may prepare a Summary report using the product_name or the area field. Any filters may be applied to each of the reports. Further, each of the...","og_url":"https:\/\/docs.extraview.com\/v25\/single-group-layouts-1\/","og_site_name":"Product Documentation","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v25\/single-group-layouts-1\/","url":"https:\/\/docs.extraview.com\/v25\/single-group-layouts-1\/","name":"Single 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\/single-group-layouts-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/single-group-layouts-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/single-group-layouts-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":2,"name":"Single 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\/23794","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=23794"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23794\/revisions"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=23794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}