Hi
I am have created a price list report which uses a matrix table within a list box to list product codes horizontally rather than vertically. I have run into some problems trying to add some finishing touches. Each product is generally split into 5 subproducts, however there are some that have less, what I am trying to do is get Reporting services to add N/A in the columns that are missing. I have attached two Images Before.jpg shows what it is like currently and After.jpg is what I am aiming for.
Is there a way to do this? Any help would be appreciated.
Regards
Paul