BIP Conditions Functions

BIP Conditions/Syntax

1. Date:

1.1. Shows system date and time (Hours: Minutes: Seconds) like 20-05-2012 13:20:40 use below condition.

Ex: <?xdoxslt:sysdate('DD-MM-YYYY HH24:MI:SS')?>

1.2. We use the below condition when user require showing date and timing with AM and PM in report:

Ex: <?format-date:(psfn:getCanonicalDate(ssTmBookingDate)); 'DD-MMM-YY hh:mm:ss AM'?>

2. Addition:

To add two field values we use the below condition:

Ex: <?xdoxslt:format_number(((xdoxslt:to_number(ssTmcvJcMaterialAmount) + xdoxslt:to_number(ssTmLabourAmount)), 2, 'gb-GB')?>

3. Subtraction:

To Subtract two field values we use the below condition:

Ex: <?xdoxslt:format_number(xdoxslt:to_number(ssAdjustedListPriceDisplay) - xdoxslt:to_number(ssTmTotalTaxAmount), 2, 'gb-GB')?>

4. Multiplication:

To Multiply two field values we use the below condition:

<?xdoxslt:format_number(((xdoxslt:to_number(ssAdjustedListPriceDisplay) * xdoxslt:to_number(ssTmDnrmPreTaxDiscount)), 2, 'gb-GB')?>

5. Or Condition:

Suppose if user require status equal to “shipped” or status equal to “new” or status equal to “pending” we need to display the report if not it shows blank at that time, then we use the below condition:

<?if:(ssStatus='Shipped') or (ssStatus='New') or (ssStatus='Pending')?>

6. Total:

The below condition depends on user requirement where sum of field values divide with another field value:

<?xdoxslt:format_number((xdoxslt:to_number(sum(ssTmcvJcMaterialAmount)) div 10000))), 2, 'gb-GB')?>

7. Displays Amount in words:

We use the below condition when user wants total value or sum of field values like total item price value in Words but not in figure:

<?xdoxslt:toWordsAmt(xdoxslt:to_number(ssTotalItemPrice?>

8. Set/Get Variable:

We use the below condition when total amount and grand total amount doesn’t display exact values in the report:

<?xdoxslt:set_variable($_XDOCTX, ‘CT’, 0)?>
<?xdoxslt:set_variable($_XDOCTX, ‘CT’,