VB.NET - Hiding columns in vb.net
Asked By Sreya Gopal on 19-Feb-12 05:59 AM
How can we hide a column in crystal report if it doesn't contains any value
Sandeep Mittal replied to Sreya Gopal on 19-Feb-12 06:23 AM
Supress in crystal report is used to hide the column.
Use supress, add the formula to supress on the column based on flag (Visible - true/false).
Sreya Gopal replied to Sandeep Mittal on 19-Feb-12 06:26 AM
OK,i am able to suppress the blank field,but how can i hide that column
kalpana aparnathi replied to Sreya Gopal on 19-Feb-12 01:18 PM
hi,
Try with this:
if {?ShowThisField1} = "true" then
formula = True
else
formula = False
end if
Where {?ShowThisField1} is the parameter. This is the Basic Syntax.
####Alternative way:
formula = {?@BooleanVariable}
Venkat K replied to Sreya Gopal on 19-Feb-12 11:52 PM
There are two ways where you can hide a column:
select a column u want to hide ----> apply alerter---> give condition if is null of the object-----> then write a formula (mention next object in the table)
one more way as :
select the table --> goto properties tab---> uncheck show empty columns.
Thanks