Prev: Beginner question
Next: How to not send subscriptions when aa report has no data in MSRS
From: Antonio Collins on 30 Jun 2008 20:30
When exported to Excel, any fixed columns with repeating values in a matrix
report are merged into a single cell. In the example below, MD and VA will
be merged into a cell that spans 2 rows and 3 rows respectively.

MD. . . Baltimore
.. . . . . Fredrick
VA. . . Alexandria
.. . . . . Fairfax
.. . . . . Richmond

This makes it next-to-impossible to work with the data in Excel. For
instance, the data can't even be re-sorted without unmerging the MD and VA
cells. And after the merge is undone, the 2nd, 4th, and 5th rows have blank
values in the first column.

Is there any way to force a matrix report to stop hiding repeating values
and display AND export all of its data? (I honestly can't believe this
ability is not available.)
 | 
Pages: 1
Prev: Beginner question
Next: How to not send subscriptions when aa report has no data in MSRS