Export Matrix report to Multiple Excel Worksheets

• Mel3405

  SSCommitted

  Points: 1904

  More actions

  June 1, 2010 at 2:03 pm

  #225208

  I have a matrix report (2008) containing about 30 columns and 200,000 rows. I came accross an article on how to populate the data on multiple worksheets. http://msdn2.microsoft.com/en-us/library/ms157328.aspx It requires that you set a group with a grup expression on X number of rows, then you page break on the group. The problem is that I don't understand how to do this using a Matrix. There are so many groups already, I don't know where to insert the new group. Is this even possible on a Matrix?

• veeren4urs

  SSCrazy

  Points: 2763

  More actions

  June 2, 2010 at 3:23 am

  #1175156

  Hi,

  To make the Matrix regions to display on different worksheets, you can set the PageBreakAtEnd property to True in the properties.

  Thanks,

  Veeren.

  Thanks & Regards,
  Veeren.
  Ignore this if you feel i am Wrong. 😉