Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
antonio.collins
Starting Member
2 Posts |
 Posted - 2008-06-30 : 19:06:36
|
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 FredrickVA 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.) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-03 : 04:44:13
|
| How is data coming from your dataset? are MD,VA values from grouping field? |
 |
|
|
|
|
|
matrix report exported to excel