Hide column when there is no record.

[Muhammad]

Hi all,

I'm creating a report and populating few fields in table. Some columns don't have any record in it and I want that column along with header to be erased or let's say shifted left. 
Here is something that might explain my situation.


Item            VAT Amount             WHT Amount           Total Amount
Table            250                                                          250
Table            1150                                                        1150
Table            50                                                            50


I want this to be like this 


Item            VAT Amount       Total Amount
Table            250                   250
Table            1150                 1150
Table            50                     50


Can anybody help me out with this ?