Export to excel fit a matrix to one page
in [Reports]
|
From: Malcolm on 22 Apr 2010 12:06 Hi , I am creating a scorecard for a client which shows a range of kpi's . I would like to fit this on one page ? The excel sheet fits onto two pages when i export it .The client is quite pedantic about this . I have tried just about everything . Any suggestions will be appreciated .It is a matrix . Regards Malcolm
From: Bruce L-C [MVP] on 22 Apr 2010 12:55 I suggest instead of a matrix that you use a pivot statement in your sql statement. Pivot does the same thing as the matrix as long as you do not have a variable number of columns. I'm assuming that since this is a scorecard that it isn't variable. Then when you use a table object to show the data you have more control over the layout. -- Bruce Loehle-Conger MVP SQL Server Reporting Services "Malcolm" <malcolm.croucher(a)justenough.com> wrote in message news:##DtCXj4KHA.4264(a)TK2MSFTNGP02.phx.gbl... > Hi , > > I am creating a scorecard for a client which shows a range of kpi's . I > would like to fit this on one page ? > > The excel sheet fits onto two pages when i export it .The client is > quite pedantic about this . > > I have tried just about everything . Any suggestions will be appreciated > .It > is a matrix . > > Regards > > Malcolm >
|
Pages: 1 Prev: SSRS2008 Line Chart Axis issue Next: Export to excel fit a matrix to one page |