SSRS dynamic report width

• robert.gerald.taylor

  SSChampion

  Points: 13133

  More actions

  September 4, 2012 at 7:40 am

  #266156

  Using SSRS 2008 R2, if I programmatically hide a column, how can I shrink my report width to match the now smaller tablix width?

  Thanks,

  Rob

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  September 4, 2012 at 8:15 am

  #1533290

  Have you tried the ConsumeContainerWhitespace property?

• robert.gerald.taylor

  SSChampion

  Points: 13133

  More actions

  September 4, 2012 at 3:02 pm

  #1533532

  Setting ConsumeContainerWhitespace to True (from default False) doesn't change the report width.

• lcreagh

  Grasshopper

  Points: 15

  More actions

  December 8, 2015 at 9:35 am

  #1844707

  Has anyone figured out a solution to this? I am having the same problem. I want to dynamically hide columns in my report, so the tablix needs to be wide to accommodate all of the columns. But once certain columns are hidden, I want the report to shrink and only be as wide as is needed to show the selected columns. This works fine when rendered in the viewer, but the export to pdf shows blank pages, even when the content fits within a standard landscaped page.