I had this question after viewing Ms Access Crosstab Report with variable number of columns
I am facing a similar situation but the problem is instead of numeric columns, i have Text Fields as columns. Any addition of column (Storage_Port) does not reflect in report. However, any change in Product / Qty gets updated.
Would be obliged if i can get help.
Db is attached herewith for reference purpose.