Table Box

[siddheshmane]

HI,

What if I want to delete  a whole row from table box if a certain  condition is met.

Here I have 3 columns in a tablebox EmployeeID, ProductName, ShipmentDate.

Like: If ( IsNULL(ShipmentDate) )

          {

               //  display the row in the Table box

          }

          If ( Not IsNULL(ShipmentDate) )

          {

               // remove or Hide the row from the Table box

          }

Thanks.

[JoaquinLazaro]

HI  siddheshmane :

You should creare an auxiliar table in the script

LOAD   *

Where IsNull(ShipmentDate)

Hope this helps you

Joaquín

[jonathandienst]

You can't use conditions and expressions in a table box. You would need to do this in a straight table.

Each expression should include the If(IsNull(ShipmentDate), <your first expression>) and then ensure the option to suppress nulls is enabled. This assumes that ShipmentDate has only one possible value (including NULL) for each combination of the dimensions.

[siddheshmane · Accepted solution]

Hi,

I got the answer what I was looking for. I just had to write this condition

IF(Len(Trim(FIELD_NAME) = 0, FIELD_NAME).