![\"\"](\"https:\/\/www.mrc-productivity.com\/docs\/images\/redundantdata1.jpg\")
<\/p>\n<\/p>\n
Let’s say we have a Report coming from two tables — a header table and a detail table. If there are 20 detail records for 1 header record, that header record’s information is going to repeat 20 times, one for each detail record. See below:<\/p>\n
<\/p>\n
It is common for customers to want to see this header information listed only once. Here are two different ways to do that:<\/p>\n
Method 1: Showing Header Information in Line Once per Section<\/strong><\/p>\n After compiling your application, open m-Painter and toggle the Source code.<\/p>\n Search for I will use Freemarker Functionality to only show each Header Information (customer number and customer name) once per section. Newly added code is in red Bold Face.<\/p>\n The Freemarker code states above that if the customer number (row.CUSNO) for the current record is not equal to the previous record’s customer number, print the Customer Number (CUSNO) & the Customer Name (CNAME). Otherwise, ignore that section.<\/p>\n In my case, I want to display the customer number and customer name fields only when the customer number (row.CUSNO) changes. In your case you will replace CUSNO in\u00a0<!–<#if row.CUSNO != var >–> and <!–<#assign var = row.CUSNO >–> with a field from your application. When the value of this field changes from record to record, the fields inside the freemarker #if tags will be output.<\/p>\n Here is my output:<\/p>\n Method 2: Showing Header Information Above Records<\/strong><\/p>\n Similar to Method 1, the Header information will only appear once, except now, we will add the header information in its own row above the Detail Section.<\/p>\n I will use Freemarker Functionality to only show each Header Information once above each Detail Line. Newly added code is in red Bold Face.<\/p>\n The Freemarker code above states that if the current record’s customer number (row.CUSNO) is not equal to the previous record’s customer number, create a new row, and a new data cell (notice that the colspan value should equal the number of columns you have). Once the data cell is created, print the Customer Number (CUSNO) & the Customer Name (CNAME). Otherwise, ignore that section.<\/p>\n Note:<\/strong> I also removed the Customer # and Customer Name from the Detail, Subtotal, Grand Total, and Header sections.<\/p>\n Here is my output:<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" Modifying Redundant Data within Reports with Freemarker Let’s say we have a Report coming from two tables — a header table and a detail table. If there are 20 detail records for 1 header record, that header record’s information is going to repeat 20 times, one for each detail…<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"open","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[],"ht-kb-tag":[],"class_list":["post-1039","ht_kb","type-ht_kb","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/ht-kb\/1039","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1039"}],"version-history":[{"count":21,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/ht-kb\/1039\/revisions"}],"predecessor-version":[{"id":10208,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/ht-kb\/1039\/revisions\/10208"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1039"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=%2Fwp%2Fv2%2Fht-kb-category&post=1039"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=%2Fwp%2Fv2%2Fht-kb-tag&post=1039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}section.lastDetail<\/code> as this will take you directly above the Detail Section.<\/p>\n\r\n<!-- END_SORT_TABLE_HEADER -->\r\n\r\n<!-- END_REPORT_TABLE_HEADER -->\r\n\r\n<!--<#assign var = 'x'>-->\r\n\r\n<!-- <#list report as section> -->\r\n\r\n<!-- <#assign lastRow = section.lastDetail \/> -->\r\n\r\n<!-- <#assign grandTotal = grandTotal0 \/> -->\r\n\r\n<!--<#if ( section.subtotalsc.size() > 0)> -->\r\n\r\n<!-- <#assign subTotal1 = section.subtotalsc[1] \/> -->\r\n\r\n<!--<\/#if> -->\r\n\r\n<!-- <#list section.detailRows as row> -->\r\n\r\n<tr class=\"ten\" nowrap =\"nowrap\" align=\"right\">\r\n\r\n<!--<#if row.CUSNO != var>-->\r\n\r\n${row.CUSNO?html}\r\n\r\n<!--<\/#if>-->\r\n\r\n<\/td>\r\n\r\n<td nowrap =\"nowrap\" align=\"left\">\r\n\r\n<!--<#if row.CUSNO != var >-->\r\n\r\n${row.CNAME?html}\r\n\r\n<!--<\/#if>-->\r\n\r\n<\/td>\r\n\r\n<td nowrap =\"nowrap\" align=\"left\">${row.PRDNO?html}<\/td>\r\n\r\n<td nowrap =\"nowrap\" align=\"left\">${row.CLASS?html}<\/td>\r\n\r\n<td nowrap =\"nowrap\" align=\"right\">${row.MTDUD?html}<\/td>\r\n\r\n<\/ tr >\r\n\r\n<!--<#assign var = row.CUSNO >-->\r\n\r\n<!-- <\/#list> -->\r\n<\/pre>\n![\"\"](\"https:\/\/www.mrc-productivity.com\/docs\/images\/redundantdata2.jpg\")
<\/p>\n\r\n<!-- END_SORT_TABLE_HEADER -->\r\n\r\n<!-- END_REPORT_TABLE_HEADER -->\r\n\r\n<!--<#assign var = 'x'>-->\r\n\r\n<!-- <#list report as section> -->\r\n\r\n<!-- <#assign lastRow = section.lastDetail \/> -->\r\n\r\n<!-- <#assign grandTotal = grandTotal0 \/> -->\r\n\r\n<!--<#if (section.subtotalsc.size() > 0)> -->\r\n\r\n<!-- <#assign subTotal1 = section.subtotalsc[1] \/> -->\r\n\r\n<!--<\/#if> -->\r\n\r\n<!-- <#list section.detailRows as row> -->\r\n\r\n<!-- <#if row.CUSNO != var > -->\r\n\r\n<tr>\r\n\r\n<td colspan =\"3\" nowrap =\"nowrap\" align=\"left\">Customer # ${row.CUSNO?html} | Customer Name ${row.CNAME?html} <\/td>\r\n\r\n<\/tr>\r\n\r\n<!-- <\/#if> -->\r\n\r\n<tr>\r\n\r\n<td nowrap =\"nowrap\" align=\"left\">${row.PRDNO?html}<\/td>\r\n\r\n<td nowrap =\"nowrap\" align=\"left\">${row.CLASS?html}<\/td>\r\n\r\n<td nowrap =\"nowrap\" align=\"right\">${row.MTDUD?html}<\/td>\r\n\r\n<\/tr>\r\n\r\n<!--<#assign var = row.CUSNO >-->\r\n<!-- <\/#list> -->\r\n<\/pre>\n![\"\"](\"https:\/\/www.mrc-productivity.com\/docs\/images\/redundantdata3.jpg\")
<\/p>\n