Not getting some data on BI publisher report
I am working on purchase order template on BI publisher, I am facing some problems as follows,
1. How can I generate sequence number.
2. How grouping is possible if there is more than one item information on PO.
3. How can I get requisition number, requisition date and RFQ number on PO.
4. When a tax is applied the table of 'Amount incl. Tax' gives correct figure, but in case if there is no tax is applied on PO than the column gives result 'NaN'.
5. How can I get amount in words at the end of the report.
Regards,
Sadiq Zaki