Hide column when there is no record.

1 posts, 0 answers
  1. Muhammad
    Muhammad avatar
    27 posts
    Member since:
    Oct 2017

    Posted 09 Mar 2018 Link to this post

    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 ?

Back to Top