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)
