Blank Matrix Table Columns

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Blank Matrix Table Columns

Blank Matrix Table Columns

Rate Topic

Display Mode

Topic Options

Author

Message

Paul Moss

Posted Monday, November 12, 2012 2:36 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 05, 2013 4:16 AM
Points: 4, Visits: 20

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

Post Attachments

Before.jpg (13 views, 10.77 KB)

After.jpg (9 views, 16.15 KB)

Post #1383564

robert.gerald.taylor

Posted Monday, November 12, 2012 8:02 AM

Right there with Babe

Group: General Forum Members
Last Login: Today @ 2:31 AM
Points: 733, Visits: 781

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

Post #1383715

« Prev Topic | Next Topic »

Permissions