Post reply

Blank Matrix Table Columns

  • November 12, 2012 at 2:36 am

    #266852

    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

  • November 12, 2012 at 8:02 am

    #1558192

    Paul Moss (11/12/2012)

    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.

    Use an expression something like:

    IIF(IsNothing(Fields!YourField.Value), "N/A", Fields!YourField.Value)

    HTH,

    Rob

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply