Matrix in List->Export to Excel->Groupings gone

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.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Matrix in List->Export to Excel->Groupings gone

Author

Topic

jacksonyeow
Starting Member

4 Posts

Posted - 2009-05-26 : 04:57:43

Hi,

After setting my matrix within a list, the report is perfect in that the matrix repeats itself according to the expression i set in the list properties.

Only issue is that when i export it as a excel file, only the first matrix has its contents grouped accordingly while the subsequent repeated ones becomes "static" and ungrouped - A very long list.

I worked around it and found 2 solutions:
1) Manually create 4 "matrix within list" separately, and add a hardcoded unique filter to each list.

2) Use the original method but insert page break after each matrix (The list becomes multi paged?)

Further problem with (1) is that whenever there are changes to the database (Add a new component and hence there should be one more matrix), I gotta come back to this source to add in a new "matrix within list" and its unique filter!? -Sweats-

Further problem with (2) is that the Ops Team demands the report to be 1 page!!! -Faints-

Is there a "small lil button that i forgot to tick" in order to allow me to use the original and intuitive method while ensuring the grouping is still there for the subsequent repeated matrices.

lol, any help greatly appreciated!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-05-26 : 12:40:39

Not sure i understand you correctly. are you speaking about grouping applied to matrix? is this working fine when viewing in report viewer?

jacksonyeow
Starting Member

4 Posts

Posted - 2009-05-26 : 20:27:28

quote:
Originally posted by visakh16

Not sure i understand you correctly. are you speaking about grouping applied to matrix? is this working fine when viewing in report viewer?

Yup! the grouping applied to matrix - Is there any small lil thing to take note of in order to ensure the groups remains in an excel file?.

The matrix is within a list to repeat the no of matrices, was working fine in report viewer.

however, when i import the report as an excel file, the report turned awry in that the repeated matrices become ungrouped - thus a very long list.

jacksonyeow
Starting Member

4 Posts

Posted - 2009-05-26 : 23:02:47

[Results that i want]