Note that the EMPLOYEE_ID element forĮmployee Michael Hartstein has the MANAGER attribute with the value Of employee data when the EMPLOYEE_ID element includes a "MANAGER"Īssume data as shown below. In this example, the Excel template suppresses the display of the row XDO_?DEPT_TOTAL_SALARY? to the field that is to display theĭEPT_TOTAL_SALARY from the data, as shown in Figure 3-27.Įxample: Skipping a Row Based on Data Element Attribute In the Excel template, assign the defined name 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Īpplied 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 You can have multiple underline styles defined for a single cell. Supported Values (Must be in returned by evaluation in Column B) Name XDO_?TYPE?, which is populated based on the string returned fromĬode performed in the subtemplate, as shown in Figure 3-25. In the Excel template, you have defined a field with the XDO Defined Parameter named pPayType and based on the value, will return a string Table 3-9 Calling a Subtemplate Column A EntryĮxample: Importing and Calling a SubtemplateĪssume you have the following subtemplate to evaluate the value of a Names each worksheet the name of the department with the number of employees in the department, for example: Sales-21.Įnter the defined names for each cell of employee data and create the group for the repeating employee data, as shown in Figure 3-17.
This example:Ĭreates a new worksheet for each department Using the employee data shown in the previous example. In this case, youĮxample: Splitting the data into multiple sheets Worksheets and the burst data should begin on Sheet3. You must enter this parameter if, forĮxample, you have a report that contains summary data in the first two If this parameter is notĮntered, BI Publisher applies the naming to the first sheet in the Sheet to begin the specified sheet naming. The original sheet name entry in Column C tells BI Publisher on which Names each sheet using the value of DEPARTMENT_NAME concatenated with "-" and the count of employees in the DEPT group. TheĮxpression can reference a value for an element or attribute in the XMLĭata, or you can use the string operation on those elements to define InĬolumn B enter the XSL expression to derive the new sheet name. Use XDO_SHEET_NAME_? to define the name to apply to the sheets. For more information, see Section 3.6, "Preprocessing the Data Using an XSL Transformation (XSLT) File." The data, define the transformation in an XSLT file, then specify thisįile in the Preprocess XSLT File field of the header section of the XDO If the data is flat, then you cannot use this command unless youįirst preprocess the data to create the desired hierarchy. XDO_SHEET_? must refer to an existing high-level node in the XMLĭata. Note that employees are grouped and listed under the The sample data for this example is a list of employees byĭepartment. Save the results as an XML file to a local directory If no layouts are defined for your report, then the output type will default to xml, otherwise, choose data for the output type. You need sample data in order to know the element names and the hierarchical relationships to properly mark up the template.įrom the Report Editor or from the Reports page, select View. 3.3.1 Step 1: Obtain Sample XML Data from the Data Model
0 kommentar(er)
