Hide Column in Table

[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

[Alex K.]

Hello,

Please try to use the DockStyle property.

Thank you.

[shan]

Hi,

Thanks for your update. Its worked fine.

Wish you advance happy Christmas and New Year !

Regards,
Shan

[Andrew]

Hello,

Thank you. You too))).

Thank you.

[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

[Deepika]

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

[Deepika]

Hi I too have the scenario. can u pls tell me how to hide the entire column using conditions

[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

[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 5080 times

Error.PNG (11.18 KiB) Viewed 5080 times

[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