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
Condition.PNG (22.05 KiB) Viewed 6122 times
Error.PNG
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