Friday, March 25, 2022

ERP - BI report XML output using XSL template


Here, we will create a custom fields XML Output BI report using XSL template.

Check my previous blog how to create BI report using xsl template

.xsl template used:

<?xml version="1.0" encoding="utf-8"?><xsl:stylesheet version="2.0" xmlns:xsl="">

<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>

<xsl:template match="/">


<xsl:element name="SupplierData">

<xsl:for-each select="DATA_DS/G_1">

<xsl:element name="Supplier">

<xsl:element name="SUPPLIER_NAME">

<xsl:value-of select="SUPPLIER_NAME"/>


<xsl:element name="SUPPLIER_NUMBER">

<xsl:value-of select="SUPPLIER_NUMBER"/>


<xsl:element name="SUPPLIER_ID">

<xsl:value-of select="SUPPLIER_ID"/>


<xsl:element name="COUNTRY">

<xsl:value-of select="COUNTRY"/>


<xsl:element name="CITY">

<xsl:value-of select="CITY"/>


<xsl:element name="STATUS">

<xsl:value-of select="STATUS"/>








Dont forget to change the default format from html to xml.

Output report:

No comments:

Post a Comment

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...