Page 1 of 2
Hide Column in Table
Posted: Fri Dec 20, 2013 11:59 am
by shan
Hi,
I want to hide the whole column if all rows are empty in a particular column in table band.
Now i am getting blank space when using conditions for the particular column, kindly find the attached image.
So kindly suggest how to solve the above mentioned issue.
Regards,
Shan
Re: Hide Column in Table
Posted: Fri Dec 20, 2013 1:16 pm
by Alex K.
Hello,
Please try to use the DockStyle property.
Thank you.
Re: Hide Column in Table
Posted: Mon Dec 23, 2013 12:55 pm
by shan
Hi,
Thanks for your update. Its worked fine.
Wish you advance happy Christmas and New Year !
Regards,
Shan
Re: Hide Column in Table
Posted: Mon Dec 23, 2013 1:03 pm
by Andrew
Hello,
Thank you. You too))).
Thank you.
Re: Hide Column in Table
Posted: Tue Feb 27, 2018 9:22 am
by Deepika
Hi. How to hide column based on the values in it.
I need to hide the entire column if all the values in it are null
Re: Hide Column in Table
Posted: Tue Feb 27, 2018 9:23 am
by Deepika
shan wrote:Hi,
I want to hide the whole column if all rows are empty in a particular column in table band.
Now i am getting blank space when using conditions for the particular column, kindly find the attached image.
So kindly suggest how to solve the above mentioned issue.
Regards,
Shan
Can u pls tell me how u achieved hiding the column
Re: Hide Column in Table
Posted: Tue Feb 27, 2018 10:07 am
by Deepika
Hi I too have the scenario. can u pls tell me how to hide the entire column using conditions
Re: Hide Column in Table
Posted: Thu Mar 01, 2018 6:18 am
by Edward
Hi Deepika,
There is a way to do that.
Please set DockStyle=left for all the text components in the Databand. The text components will form a stack to the left side of the page one by one.
Open a condition property of the component and set the condition as the following topic suggests:
viewtopic.php?f=8&t=39639&hilit=dbnull.value&start=10
Thank you,
Edward
Re: Hide Column in Table
Posted: Fri Mar 02, 2018 4:51 am
by Deepika
Hi Alex.
I m getting the below error if use DbNull in my condition.
Condition : Transaction_Report.ASA = DbNull.Value
Error : DbNull does not exist in the current context.
One more clarification. Where I should give the condition. In header or in row?

- Condition.PNG (22.05 KiB) Viewed 6122 times

- Error.PNG (11.18 KiB) Viewed 6122 times
Re: Hide Column in Table
Posted: Fri Mar 02, 2018 7:10 am
by Edward
Hi Deepika,
Please try to change the expression as it was suggested in the 1st page of that post I kindly mentioned to you:
viewtopic.php?f=8&t=39639&hilit=dbnull.value
Transaction_Report["ASA"] == DbNull.Value
Thank you,
Edward