w3apex

  I want to display one message if parameter is null. I used <?if:ACCT_ID='MAND'?> ****No Report Output***   <?end if?> <?if:ACCT_ID!='MAND'?> the whole document <?end if?> but in first case header and footer is also getting displayed. Can we avoid this? Thanks.

Use Case 1  • Show data in tabular format.  • Provide a Report Name • Repeat Table Header in each page.  • Sort data in descending order using Invoice Number.  <?sort:INVOICE_NUM;'descending'?>  • Show or Limit only 10 records per page.  <?if:position() mod 10 =0?> <xsl:attribute name="break-before">page</xsl:attribute> <?end if?>  • Show “NO DATA FOUND” if query doesn’t fetch any data <?choose:?> <?when:count(INVOICE_NUM) > 0?> <?end when?> <?otherwise:?> NO DATA FOUND <?end otherwise?> <?end choose?>  RTF Template in BI Publisher  Use Case 2  • Show PO Header Information in Form Layout and PO Lines in Table Layout.  • Provide a Report Name • Add Header to insert company logo on the left side and Date Timestamp using extended XSL Function on the right <?xdoxslt:sysdate('DD-MON-YYYY HH24:MI')?>  • Always show a PO from a new Page <?split-by-page-break...

 https://www.youtube.com/watch?v=oMIKpbOB1sk

  https://www.youtube.com/watch?v=abX-CrcFnYs

  https://www.youtube.com/watch?v=Q4s6hZRgBdc&t=10s

 

 --------IF, IF Else Condition, Case-When - In RTF Template--------- <?if:P8_AREA!=''?>Area Name:<?P8_AREA?><?end if?> ------------------------------------------------- ----------------------IF ELSE------------------ 1. <?if:dname!=''?><?dname?><?end if?> --dname is not null then show dname 2. <?if:count(cd)>4?><?end if?> 3. <?if:sum(cd/price)>100?><?end if?> 4. if country=uk multiple the price by 1.6 convert to usd.    <?if:country='uk'?><?price*1.6?><?end if?>    <?if:country!='uk'?><?price?><?end if?> ---------------------Xdofx-------------------------- 1. Xdofx:if is use when we need an situation where if else can be used. for example 2. if country =uk the price*1.6 else price 3.Or if category type="cd" then display new wave else old wave 4. <?xdofx:if country='uk' then price*1.6 else price end if?> 5. <?xdofx:if ./@cattype...