WORD and Excel format

• daniarchitect

  SSCommitted

  Points: 1727

  More actions

  October 19, 2016 at 7:13 am

  #318275

  Experts,

  SSRS 2012 when exporting report user wants different format for Excel and Word.

  The report has 200 pages

  user wants:

  in EXCEL: all 200 on same tab.

  in Word : 1 per page

  please help

• compufreak

  SSC Eights!

  Points: 951

  More actions

  October 28, 2016 at 12:11 am

  #1909292

  have you tried this :

  set the InteractiveSize >>>>> Height property to 0cm:

  this will work fine in excel as it will squeeze everything into one tab.... but i am not sure about how it would look in MS word.