How to Hide Null Column/Field in a Access Report 2007?

[mubarik76]

Hi Every One,
I need to hide null value column in my report. I have a table that have 50 column e.g.
Date, ID, Name, col1, col2, col3, col4...........
but in a record all column have not value e.g first three column must have value but next 47 column have random values if first record have value in col10, col32 and col41 then the next may b have col10,31,39,44 etc. i want only report show like if john have values in 3 column and steave have values in 7 column/fields then in report only show the john 3 field and steave show only 7 fields/column. Is this possible please advise.
Thanks.

[June7]

If column is needed for one record, it must be there for all.

Does not sound like normalized data structure.