We will be modifying the A4 – portrait template in this example.\u00a0 There are 2 parts to this – we want to remove the functions listing:<\/p>\n
![\"\"](\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/04\/dbdoc_remove_functions_01.png\")
<\/p>\n
and also the functions details:<\/p>\n
![\"\"](\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/04\/dbdoc_remove_functions_02a.png\")
![\"\"](\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/04\/dbdoc_remove_functions_02.png\")
<\/p>\n
<\/p>\n
First, select the default template and click on the Edit<\/strong> button.<\/p>\n <\/p>\n Save this template under a new name, so that we can still use the default template and also this template that excludes the functions details.<\/p>\n <\/p>\n To remove the listing, click on the TableOfContents<\/strong> tab.<\/p>\n <\/p>\n Scroll down the report until you see the TOCFunctionHeader<\/strong> band.\u00a0 Click on the band, and set its Visible<\/strong> property to False<\/strong>.<\/p>\n <\/p>\n Repeat the same process for the 2 bands below the TOCFunctionHeader<\/strong> band i.e. click each time on the TOCFunction<\/strong> and TOCFunctionFooter<\/strong> bands, and set the Visible<\/strong> property to False<\/strong>.<\/p>\n <\/p>\n Click on the Preview<\/strong> button to preview the report.<\/p>\n <\/p>\n The functions listing should no longer appear.\u00a0 That takes care of the listing.\u00a0 To remove the function details, first click on the SchemaObjects<\/strong> tab.<\/p>\n <\/p>\n Locate the FunctionsListingHeader<\/strong> band.\u00a0 Again, you will need to set this band’s visibility to false, and that of the next 5 bands (DetailData4<\/strong>, FunctionGroupHeader<\/strong>, FunctionDetails<\/strong>, FunctionDetailsDefinition<\/strong>, and FunctionDetailsComment<\/strong>).<\/p>\n <\/p>\n Click Preview<\/strong> again and the function details should no longer be displayed.\u00a0 However, there are 2 empty pages between the sequences and trigger functions pages because the function bands start a new page when they print (even though they are not visible, the underlying code still runs).<\/p>\n To remove the first empty page ,select the FunctionsListingHeader<\/strong> band, and click on the Events<\/strong> tab.<\/p>\n This brings up the code editor, where we can see that the report template starts the functions listing on a new page, causing us to have a blank page when the listing is not displayed.<\/p>\n <\/p>\n To remove the blank page, comment out the Engine.NewPage;<\/strong> line by adding two forward slashes at the beginning of that line i.e.<\/p>\n <\/p>\n Repeat the same process for the FunctionsGroupHeader<\/strong> band.\u00a0 In the OnBeforePrint<\/strong> event, comment out the line that starts a new page.<\/p>\n <\/p>\n You can follow the same steps if you want to remove any other sections from the report.\u00a0 Note that the PDF and Word reports share the same template, so you only need to modify one template.<\/p>\n If you require further assistance, do drop us a line at support@yohz.com<\/a>.<\/p>\n <\/p>\n![\"\"](\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/04\/dbdoc_remove_functions_03a.png\")
<\/p>\n![\"\"](\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/04\/dbdoc_remove_functions_03.png\")
<\/p>\n![\"\"](\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/04\/dbdoc_remove_functions_04.png\")
<\/p>\n![\"\"](\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/04\/dbdoc_remove_functions_05.png\")
<\/p>\n![\"\"](\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/04\/dbdoc_remove_functions_06.png\")
<\/p>\n![\"\"](\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/04\/dbdoc_remove_functions_07a.png\")
<\/p>\n![\"\"](\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/04\/dbdoc_remove_functions_08.png\")
<\/p>\n![\"\"](\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/04\/dbdoc_remove_functions_18.png\")
<\/p>\n![\"\"](\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/04\/dbdoc_remove_functions_13.png\")
\nDouble click on the FunctionsListingHeaderOnBeforePrint<\/strong> item.<\/p>\n![\"\"](\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/04\/dbdoc_remove_functions_14.png\")
<\/p>\n![\"\"](\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/04\/dbdoc_remove_functions_15.png\")
<\/p>\n![\"\"](\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/04\/dbdoc_remove_functions_16.png\")
<\/p>\n![\"\"](\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/04\/dbdoc_remove_functions_17.png\")
<\/p>\n