I am facing a problem for removing null() or spaces in tablebox.
Requirement: when Tab:Teacher is null then all Column will disappear
I am already used this below:
1) I am already used trim() in script level
2) In Table Box -> presentation -> i am checked Omit Rows where field is null
plz help me ASAP
If you want to treat spaces as null, try this in the script load:
If(Trim(Teacher) = '', Null(), Teacher) As Teacher
Then In Table Box -> presentation -> check Omit Rows where field is null.