Home Forums Reporting Services Reporting Services 2005 Development SSRS 2005 Display Columns in a matrix report even if no data is present in the sql table RE: SSRS 2005 Display Columns in a matrix report even if no data is present in the sql table

  • August 6, 2012 at 7:36 am

    #1522036

    I am having a very similar issue, except in SSRS 2008. I have a matrix table, with "Accounts" as rows and "Locations" as columns. The data is a money sum value. Basically, I would like to have all Locations (columns) display even when there is no data. Right now, only the columns with data show. Any advice would be greatly appreciated!