Example:

I have a form that tracks how many pounds of apples and how many pounds of oranges I buy for the day at my 3 different locations. The fields for the apples and oranges are decimal fields and the field for location is a drop down box. I then create a report and I put the locations in the column box and i place the fields for apples and oranges in the data box. This then gives me a report that displays the total weight of each fruit bought at each store and then a summary showing me the total when combining all 3 stores. The reports works great but lets say I do not buy any apples for the day at 2 of my locations. Currently the report would simply display a 0 in the apple columns for those 2 locations. However the report would be easier to view and print if instead of displaying a 0 the report just left out any columns that do not have a value higher than 0. 

My actual situation has roughly 20 items at 3 locations which generates roughly 80 columns once the summary is included. This is obviously impossible to print and very difficult to view once exported and sent via email. On most days we may only buy 1 of these items at one location, 2-3 at another, and maybe even none of them items at the 3rd location. Is there a way to tell the report to only display those columns that have a value greater than 0? This would condense my report from 20 columns to 15-20 nightly. Thanks in advance!