Do not display one column if all item data is null

[XiaoJun]

Hi..anyone can help me??? may i ask?

Is it possible to not display or hide one column even the group header if all data in that column is null??

Thank you,
XJ

[Andrew]

Hello,

For example you can do it this way:
- Before the starting band building, define in the script that all data in that column is null, and remember this in a variable;
- Set DockStyle = Left for all columns which are placed on the right against the required one.
- By the value of the variable, disable all textboxes in the required column using the Condition.

Thank you.

[XiaoJun]

Hello Andrew,

thanks for your advice, your advice really helped me.....Finally my problem has been solved.
I followed the step one for creating a variable to define the null, but i can not set Dock Style = left because that make their arrangement of column become very messy.
I using this way :
- define a variable in the script that if all data in that column is null
- in the required column set condition : if variable is null then disable
- two textbox (one is more longer till hide the required null column) in column beside the required one
- and setting condition for the two textbox : if variable is not null then disable the longer one and the opposite

I don't know is it the best way, but this can solved my problem. :amazed:

XJ

[Ivan]

Hello,

Let us know if you need any additional help.

Thank you.

[XiaoJun]

Thanks Andrew & Ivan :amazed:

[Andrew]

Have a nice day!