conditional row output

Hi all,
is it possible to control row output on a report?
We are using MS Analysis Services Cubes as datasource and
experience some difficulties displaying ragged
hierarchies (parent child dimensions).
Reporting Services will create a subtotal for each group,
even if that group only contains a single item.
Is there a way to say "skip total when there is only one
item" ?
TIA Lutz MorrienYou might try to use a conditional iff
IIF, and the count function to count the members in the group. If the member
count > 1 show the field, else hide the field.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Lutz Morrien" <anonymous@.discussions.microsoft.com> wrote in message
news:8ceb01c47878$521cbc00$a601280a@.phx.gbl...
> Hi all,
> is it possible to control row output on a report?
> We are using MS Analysis Services Cubes as datasource and
> experience some difficulties displaying ragged
> hierarchies (parent child dimensions).
> Reporting Services will create a subtotal for each group,
> even if that group only contains a single item.
> Is there a way to say "skip total when there is only one
> item" ?
> TIA Lutz Morrien|||Thank you Wayne,
it is indeed possible to control the visibility of a
field or a group using an iif construct.
Grouping on customer, I used the following:
=iif(count(Fields!Customer.Value)>1,True,False)
However, it seems that by hiding a group all groups
contained in this group plus all contained detail data is
hidden as well.
I just want RS not to calculate a total if there is only
one set of detail data. Hiding the detail data by hiding
the total is not really an option.
Thanks Lutz