Hi.
How do I suppress (not display) the empty fields in detail section of my report ? Table structure is as:
Order_id, Order_Value, Tax1_Amt, Tax2_Amt, Tax3_Amt
Report format is as:
Ord_id : Ord1001 Ord_val : 500000
Tax1_Amt : 12000
Tax2_Amt : 3650
Ord_id : Ord1003 Ord_val : 965000
Tax1_Amt : 1000
Tax3_Amt : 750
This is because, on some orders customer may have paid Tax1+Tax2, on some other order Tax1+Tax3 but not Tax2. In another order customer may have paid all three taxes.
So, I have to make sure I show only the Tax number paid and suppress the unpaid (empty) tax field in the detail section of my report for each order id.
Please help.
How do I suppress (not display) the empty fields in detail section of my report ? Table structure is as:
Order_id, Order_Value, Tax1_Amt, Tax2_Amt, Tax3_Amt
Report format is as:
Ord_id : Ord1001 Ord_val : 500000
Tax1_Amt : 12000
Tax2_Amt : 3650
Ord_id : Ord1003 Ord_val : 965000
Tax1_Amt : 1000
Tax3_Amt : 750
This is because, on some orders customer may have paid Tax1+Tax2, on some other order Tax1+Tax3 but not Tax2. In another order customer may have paid all three taxes.
So, I have to make sure I show only the Tax number paid and suppress the unpaid (empty) tax field in the detail section of my report for each order id.
Please help.