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.
MikeWhen 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?
"Mike Austin" wrote:
> 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.
> Mike
No comments:
Post a Comment