| **Navigation:**  [[templates.htm|Templates]] > Guide to all Templates > Wizard Themes >====== Report Customization ====== | [[tplwizardcustomizationprogresscontrols.htm|{{btn_prev_n.gif|Previous page}}]][[templates.htm|{{btn_home_n.gif|Return to chapter overview}}]][[tplwizardlabelcustomization.htm|{{btn_next_n.gif|Next page}}]] | | || {{reportcust_shg.jpg|ReportCust_shg.jpg}}[[tplwizardreportcustomization.htm#custreportadditions|]][[tplwizardreportcustomization.htm#custreportreport|]][[tplwizardreportcustomization.htm#custreportprogresswindow|]][[tplwizardreportcustomization.htm#custreportprocedure|]] The settings here control the appearance of the Report procedure generated by the Report Wizard. These settings can be saved for use in other future applications. **Procedure:** **Procedure Name** Enter a name that the Report Wizard will use to generate procedure names in your application. The template macro symbol, %FileName, is required, and extracts the Dictionary file name for each file selected by the wizard. You can modify this line with other template macros and text if you wish. No spaces are allowed in procedure names. This name is used for files that have no keys defined **Procedure "With Key"** This prompt is similar to Procedure Name, but is used for designated files that have a key (or keys) defined in the Dictionary Editor. **Progress Window** **Caption** Text that is entered on this line will be used as the description of the report's progress window, and appear in the progress window's title bar. **Background** Enter a default image here to use as a graphic or watermark for your report's progress window. **Mode** If you have designated a background image to use for your report's progress window, this option becomes available to control if the image is tiled, stretched, or centered. **Icon** Enter a default icon, or press the ellipsis button to select an icon file for use in your report's progress window. This will allow your window to be minimized if needed. **Font** Press the Font button to select a default font to use for the report's progress window. Sample text shown below the button is provided to allow you to review your selection. **Width** Enter the default width in dialog units for the report's progress window. **Height** Enter the default height in dialog units for the report's progress window. **Position** Select from the drop list to designate the initial position of your Progress window. You can center the window, or use the default position that is set by the template wizard. **Controls** There are four default controls in the Progress Window that you can customize: __Progress__TPLWizardControlCustomization __Pct Text__TPLWizardControlCustomization __User String__TPLWizardControlCustomization __Cancel Button__Button_Customization **Report Layout** {{reportreportsub_shg.jpg|ReportReportSub_shg.jpg}}[[tplwizardreportcustomization.htm#reportform|]][[tplwizardreportcustomization.htm#reportfooter|]][[tplwizardreportcustomization.htm#reportdetail|]][[tplwizardreportcustomization.htm#reportheader|]][[tplwizardreportcustomization.htm#reportgeneral|]] General The settings in this tab control refer to the settings of the current active report layout, whose name is displayed at the top. **Job Name** Enter the print job name to use for the Windows Print Manager. If omitted, the REPORT's //label// is used. The default setting is "Report %FileName". **Paper Type** Select the paper size for the report output from the drop list provided. **Paper Width** If you select "Other" as the Paper Type, you must enter a custom paper width. **Paper Height** If you select "Other" as the Paper Type, you must enter a custom paper height. **Margins** Margin setting control the printable area of your reports. Specify the Top, Bottom, Left and Right margin settings in thousandths of an inch Check the Automatic Adjust Top and Bottom box to allow auto resizing of the margins when the report header or footer heights are resized. Press the Adjust Using Header and Footer Size button to manually update the margin settings to conform to any changes made to the header and footer height positions. This button is only enabled if the Automatic Adjust Top and Bottom box is unchecked, to avoid sizing conflicts. **Orientation** Specify here what paper orientation the report layout will use (Portrait or Landscape). **Font** Press the Font Button to specify a default font to use for reports that the wizard will generate. There are several other places where you can override this setting. **Show Preview** Check this box to designate that all reports generated by the wizard will have a Print Preview window associated with it. **Preview Maximized** If the Show Preview box is checked, you can designate here that the Print Preview window will open in maximized mode (full screen). **Initial Zoom Setting** If the Show Preview box is checked, you can designate an initial zoom setting from this setting. **Header** The HEADER structure declares the output that prints at the beginning of each page or group. **Add Header** Check this box to allow your reports that are generated by the wizards to declare a HEADER section. **Background Color** If your user has support for color printing, you can designate a color to use as a background for the report's header. **Report Title** Enter a string or expression that will be used as the report title for each report generated by the report wizard. Since you can generate many report from different tables specified, it is a good idea to use a template macro here. The default is "Report //%FileName// file" **Position Y** Specify the starting position of the report title, relative to the start of the printable header area. Value is expressed in thousandths of an inch. **Justification** Specify how the contents of header text will be justified. The default is //Center//, but you can also specify //Left// or //Right// justified. **Title Font** The report title's font can be controlled with this setting. Press the //Title Font// button to designate the appearance of the title text. **Position** Enter the starting X and Y coordinates for the upper left corner of the header area, which is measured in thousandths of an inch, and relative to the upper left corner of the report's printable area. Enter the header area's width and height, also measured in thousandths of an inch **Font** Press the //Font// button to select the font (typeface), size, style (such as bold or italic), color, and font effects (underline and strikeout) for all controls in the header section. A sample of the selected font is displayed on the tab control. **Header Box** Check the Add Header box to add a box control to the report header. You will then be able to specify a color, Top (or width), and Height settings. **Detail** The detail area is the "body" of the report. Usually, your most important and relevant data will be printed here. **Background Color** If your user has support for color printing, press the ellipsis button to designate a color here to use as a background for the report's detail area. **Position** Enter the starting X and Y coordinates for the upper left corner of the detail area, which is measured in thousandths of an inch, and relative to the upper left corner of the report's printable area, or to the last item printed in the detail print area. Enter the detail area's width and height, also measured in thousandths of an inch. Think of this setting as the "record" or "row" area of your report. **Font** Press the //Font// button to select the font (typeface), size, style (such as bold or italic), color, and font effects (underline and strikeout) for all controls in the Detail section. A sample of the selected font is displayed on the tab control. **Add Detail Lines** Check this box to instruct the template to generate a horizontal line between each detail section printed. **Automatic adjust Band Height with Row Number** Check this box to instruct the template to generate the total detail area's height based on the number of rows that are calculated at design time. The number of rows calculated is based on the data elements selected to print and number of report columns designated for each row. This prevents extra white space from being generated between the last detail on the page and the page footer. **Footer** The report FOOTER area is normally used to print text and data at the end of each page. **Add Footer** Check this box to allow your reports that are generated by the wizards to declare a FOOTER section. **Background Color** If your user has support for color printing, press the ellipsis button to designate a color here to use as a background for the report's footer area. **Position** Enter the starting X and Y coordinates for the upper left corner of the footer area, which is measured in thousandths of an inch, and relative to the //lower left corner of the report's detail area//, or to the last item printed in the detail print area. Enter the detail area's width and height, also measured in thousandths of an inch. **Font** Press the //Font// button to select the font (typeface), size, style (such as bold or italic), color, and font effects (underline and strikeout) for all controls in the report's footer section. A sample of the selected font is displayed on the tab control. **Form** The Form Band is normally used to specify constant text or graphics which print on every page (for example, a watermark or a tax form) **Add Form** Check this box to allow your reports generated by the wizards to specify a Form section. **Background Color** If your user has support for color printing, press the ellipsis button to designate a color here to use as a background for the report's form band area. **Margins** Margin settings control the printable area of your form band. Specify the Top, Bottom, Left and Right margin settings in thousandths of an inch **Font** Press the //Font// button to select the font (typeface), size, style (such as bold or italic), color, and font effects (underline and strikeout) for all controls in the report's Form Band section. A sample of the selected font is displayed on the tab control. **Image** **Add Image** Check this box to allow an image control to be populated on the Form band. This check box also enables the remaining options. **Image File** Press the ellipsis button to select the name of the image file to be used in the populated image control. Any image format supported by the Windows print engine may be selected. **Mode** Select from the drop list how the image file will be rendered on the report. Select from tiled, stretched, and centered. **Image Position** If width and height are zero(0), the image will use the settings specified by the form band. Set the X and Y position to designate the anchor position of the top left corner. __**Additions**__ __Page Number Control__Report_Additions_Customization __Date and Time Control__Report_Additions_Customization