Dynamic matrix width

• DamianC

  SSCrazy Eights

  Points: 8023

  More actions

  March 17, 2016 at 3:03 am

  #316963

  Hello

  Does anybody know the easiest way to guarantee that a matrix report item will fit on a page

  I have a report that lists sales per region, per day

  Rows are regions and columns are days

  Days work on a month to date basis so day 1 will show 1 column, through to (up to) day 31 showing 31 columns

  Historically, I've been shrinking the width and font

  That kind of works

  Ideally though, I'd like to shrink width and font based upon the number of columns

  I've looked in the past and never come up with an answer

  Just been asked again as day 1 shows a very small report, so I thought I'd put it out there again

  Any ideas?

  Thanks

  Damian.

  - Damian

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  March 17, 2016 at 3:31 am

  #1865812

  Duplicate post, replies here please: http://www.sqlservercentral.com/Forums/FindPost1770164.aspx

  -- Gianluca Sartori