{"id":23830,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/reports-repeating-rows-1\/"},"modified":"2025-02-06T19:21:01","modified_gmt":"2025-02-07T03:21:01","slug":"reports-repeating-rows-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/reports-repeating-rows-1\/","title":{"rendered":"Reports with Repeating Rows"},"content":{"rendered":"

It can sometimes be important to understand the distinction that ExtraView makes between rows on a report and records on a report. This difference in semantics is used to distinguish between the times when ExtraView returns a precise number of records on a report and when it returns a set of rows<\/b><\/em> that may or may not correspond exactly to the number of records. The difference comes when a query may return a single record multiple times on a report, or count the same record multiple times on the same report. This happens when there are one-to-many relationships within your data and with repeating rows on reports. The two most common times this happens are:<\/p>\n

\n\tReporting with Repeating Record Fields<\/h3>\n
    \n
  • \n\t\tYou prepare a report that uses repeating row records, then use a repeating row field to sort the report. When you use a field on a repeating row record to sort, it will generate a row on the report for each occurrence of the repeating row. Therefore, if you have 3 repeating rows within a single issue, it will generate 3 rows<\/b><\/em> on the report for each record<\/b><\/em>.<\/li>\n
  • \n\t\tYou use reporting hierarchies. In a similar manner to the above bullet, one record at a level in the hierarchy may have multiple child records, and when you sort by a field at the child level, you will generate one row<\/b><\/em> on the report for each record<\/b><\/em>.<\/li>\n
  • \n\t\tIf you create a report and want to place any fields from the Release field on the report, you must always include the RELEASE_FOUND field on the report, as this is the key field used to extract the remaining fields from the ExtraView database.<\/li>\n<\/ul>\n

    \n\tReports that Include Repeating Row Fields from Different Repeating Row Layout Types<\/h3>\n

    When you have reports that include fields from two or more repeating row types, it can be confusing to view the results from the different layout types aligned on the same row of the report, as the data from any one repeating row record is unlikely to be related to the data from any other repeating row record.  Care should be taken when interpreting the data displayed on a report which contains data from multiple repeating row layouts.<\/p>\n

     <\/p>\n","protected":false},"excerpt":{"rendered":"

    It can sometimes be important to understand the distinction that ExtraView makes between rows on a report and records on a report. This difference in semantics is used to distinguish between the times when ExtraView returns a precise number of records on a report and when it returns a set of rows that may or…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":23769,"menu_order":8,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"no","_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-23830","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\nReports with Repeating Rows - 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\/extraview-25\/end-user-guide-1\/reporting-1\/reports-repeating-rows-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reports with Repeating Rows - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"It can sometimes be important to understand the distinction that ExtraView makes between rows on a report and records on a report. This difference in semantics is used to distinguish between the times when ExtraView returns a precise number of records on a report and when it returns a set of rows that may or...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/reports-repeating-rows-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-07T03:21:01+00:00\" \/>\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\/extraview-25\/end-user-guide-1\/reporting-1\/reports-repeating-rows-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/reports-repeating-rows-1\/\",\"name\":\"Reports with Repeating Rows - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-02-07T03:21:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/reports-repeating-rows-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/reports-repeating-rows-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/reports-repeating-rows-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ExtraView 25\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"End User Guide\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Reporting\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Reports with Repeating Rows\"}]},{\"@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":"Reports with Repeating Rows - 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\/extraview-25\/end-user-guide-1\/reporting-1\/reports-repeating-rows-1\/","og_locale":"en_US","og_type":"article","og_title":"Reports with Repeating Rows - Product Documentation","og_description":"It can sometimes be important to understand the distinction that ExtraView makes between rows on a report and records on a report. This difference in semantics is used to distinguish between the times when ExtraView returns a precise number of records on a report and when it returns a set of rows that may or...","og_url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/reports-repeating-rows-1\/","og_site_name":"Product Documentation","article_modified_time":"2025-02-07T03:21:01+00:00","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\/extraview-25\/end-user-guide-1\/reporting-1\/reports-repeating-rows-1\/","url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/reports-repeating-rows-1\/","name":"Reports with Repeating Rows - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-02-07T03:21:01+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/reports-repeating-rows-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/reports-repeating-rows-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/reports-repeating-rows-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":2,"name":"ExtraView 25","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":3,"name":"End User Guide","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/"},{"@type":"ListItem","position":4,"name":"Reporting","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/"},{"@type":"ListItem","position":5,"name":"Reports with Repeating Rows"}]},{"@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\/23830","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=23830"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23830\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23769"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=23830"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}