Hode crosstab fields

[SDS100UK]

Hi,
I have a crosstab query, when I open the report I want empty fields to be hidden.


I have tried this code in on page event
if isnull[field] then
field.visible = false
end if

I have also tried the is empty approach

but neither of them work, I have checked my data types(which are text)

Anyideas why or how I can hide empty fields.

Hope ou can help
Steven

 

[MichaelRed]

.Visible = False

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[mirirom]

you may wish to try the code on a different event such as onOpen or onActivate.

 

[SDS100UK]

Michael & Mirirom,

Possibly I mislead you.
I put field.visible=False to indicate the field name.

I have also tried putting the code elsewhere, but if the field is empty, null or zero it just will not seem to work on a report that is based on a crosstab.

Could it be something to do with the field names?

Hope you can help!!

Steven

 

[MichaelRed]

I think it is more likely to be where you are placing the code. It probably needs to be in the "on print" event. MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over