The other EMPLOYEE_ID elements in this set do not have the attribute. Note that the EMPLOYEE_ID element for employee Michael Hartstein has the MANAGER attribute with the value "True". In this example, the Excel template suppresses the display of the row of employee data when the EMPLOYEE_ID element includes a "MANAGER" attribute with the value "True".Īssume data as shown below. In the Excel template, assign the defined name XDO_?DEPT_TOTAL_SALARY? to the field that is to display the DEPT_TOTAL_SALARY from the data, as shown in the following figure:Įxample: Skipping a Row Based on Data Element Attribute The value of each of these attributes is used to apply the defined style based on logic defined in the template.
Note that the DEPT_TOTAL_SALARY element in the data has these attributes defined: In this example, a border style and an underline style are applied to the DEPT_TOTAL_SALARY field shown in the Excel template.įor this example, the following data is used. To apply a style in a template, the style value must be present in the data. You can have multiple underline styles defined for a single cell.
In the Excel template, you have defined a field with the XDO Defined Name XDO_?TYPE?, which is populated based on the string returned from code performed in the subtemplate, as shown in the following figure: This subtemplate evaluates the value of a parameter named pPayType and based on the value, return a string that indicates the payment type: