Item count in collapsed region

Initially I have collapsed regions on my report with drill-down possibility.
How can I show the number of items that are directly beneath that region?
Something like:
+ Beverages (4)
+ Cigarettes (6)
...I didnt try this, but maybe something like:
=Fields!beverages.Value & " (" &
count(Fields!sub-beverages.Value,"Group-sub-beverages") & ")"
"Marcus Phass" wrote:
> Initially I have collapsed regions on my report with drill-down possibility.
> How can I show the number of items that are directly beneath that region?
> Something like:
> + Beverages (4)
> + Cigarettes (6)
> ...
>
>|||It always says that "the scope parameter must be set to name of containing
group..." error. If I omit the scope, it counts the total number of items
below "Beverages", but I want to display only the number of items in the
level directly below (not all levels below). Countrows gives the same error.
"NI" <NI@.discussions.microsoft.com> wrote in message
news:699E0462-CDC7-4FFA-8C61-2C631672A5F4@.microsoft.com...
> I didnt try this, but maybe something like:
> =Fields!beverages.Value & " (" &
> count(Fields!sub-beverages.Value,"Group-sub-beverages") & ")"
>
> "Marcus Phass" wrote:
> > Initially I have collapsed regions on my report with drill-down
possibility.
> > How can I show the number of items that are directly beneath that
region?
> >
> > Something like:
> >
> > + Beverages (4)
> > + Cigarettes (6)
> > ...
> >
> >
> >|||Try CountDistinct. It worked I tried.
= Fields!Beverages.Value & "(" & CountDistinct(Fields!sub-beverages.Value) &
")"
"Marcus Phass" wrote:
> It always says that "the scope parameter must be set to name of containing
> group..." error. If I omit the scope, it counts the total number of items
> below "Beverages", but I want to display only the number of items in the
> level directly below (not all levels below). Countrows gives the same error.
>
> "NI" <NI@.discussions.microsoft.com> wrote in message
> news:699E0462-CDC7-4FFA-8C61-2C631672A5F4@.microsoft.com...
> > I didnt try this, but maybe something like:
> >
> > =Fields!beverages.Value & " (" &
> > count(Fields!sub-beverages.Value,"Group-sub-beverages") & ")"
> >
> >
> >
> > "Marcus Phass" wrote:
> >
> > > Initially I have collapsed regions on my report with drill-down
> possibility.
> > > How can I show the number of items that are directly beneath that
> region?
> > >
> > > Something like:
> > >
> > > + Beverages (4)
> > > + Cigarettes (6)
> > > ...
> > >
> > >
> > >
>
>|||Yep, it works! Thanks!
"NI" <NI@.discussions.microsoft.com> wrote in message
news:23233751-33C6-4AB8-9905-66251FBD7640@.microsoft.com...
> Try CountDistinct. It worked I tried.
> = Fields!Beverages.Value & "(" & CountDistinct(Fields!sub-beverages.Value)
&
> ")"
> "Marcus Phass" wrote:
> > It always says that "the scope parameter must be set to name of
containing
> > group..." error. If I omit the scope, it counts the total number of
items
> > below "Beverages", but I want to display only the number of items in the
> > level directly below (not all levels below). Countrows gives the same
error.
> >
> >
> > "NI" <NI@.discussions.microsoft.com> wrote in message
> > news:699E0462-CDC7-4FFA-8C61-2C631672A5F4@.microsoft.com...
> > > I didnt try this, but maybe something like:
> > >
> > > =Fields!beverages.Value & " (" &
> > > count(Fields!sub-beverages.Value,"Group-sub-beverages") & ")"
> > >
> > >
> > >
> > > "Marcus Phass" wrote:
> > >
> > > > Initially I have collapsed regions on my report with drill-down
> > possibility.
> > > > How can I show the number of items that are directly beneath that
> > region?
> > > >
> > > > Something like:
> > > >
> > > > + Beverages (4)
> > > > + Cigarettes (6)
> > > > ...
> > > >
> > > >
> > > >
> >
> >
> >