Groups | Blog | Home
all groups > sql server reporting services > october 2007 >

sql server reporting services : I want duplicates in my matrix!


Mike Austin
10/29/2007 10:41:13 AM
I have a very simple report that allows users to extract data to an excel
spreadsheet and work with it. It consists of a single matrix with 3 row
groups, 1 column group and 1 "fact" cell. When it is run, either in preview
or deploy mode, the report is hiding duplicate values in the first column in
the row groups. (The left-most row group.) "Hide duplicates" is most
definitely *not* checked on the properties page.

I read somewhere of a developer experiencing this problem in Visual Studio
and having the problem disappear when the report is deployed. This is not
happening for me; the report hides duplicates all the time. Did I mention
that "Hide duplicates" is definitely *not* checked? [Tongue]

I've tried re-writing the report from scratch: no joy.

Any help appreciated, as the end-users don't like having to put the
duplicate values back in so that they can work with the data in Excel.

Jimbo
10/30/2007 1:01:02 PM
When you say you want to show duplicates, what do you mean by a duplicate?

For the range you are interested in, are all rows (excluding fact cell) of
the same value?







[quoted text, click to view]
AddThis Social Bookmark Button