PLEASE! count of groups

I have a report with one group level where I am hiding detail and only
showing group totals. This report is summarized/grouped by device (like a
system name) and I am trying to calc the total number of devices monitored
which would be equal to the number of groups I have on the report. I have
tried all the aggregate functions RowNumber(nothing) to count outer most
level, CountDistinct, RowCount, CountRows ... etc etc and nothing gives me
what I want. If I were to code it ... I would have some counter that every
time I created a group footer then I would add 1 to the counter. It seems
that this should be something simple (and maybe it is!) but the expression I
am grouping on is a system name (so cant use THAT like a sum). I would do it
at the database level but I am using a stored procedure so cant modify the
sql. I tried to create (add) a field (as you would a calculated field or
database field) but got some error about out of bounds for array or
something. This is driving me nuts! please help!!!I got it to work finally. Now the problem is that I want to display the
device count in a textbox at the end of the report and I get an error trying
to reference the field I just created in the table portion of the report. In
the table (called table1 in the report) I entered the following expression
in the textbox I named DeviceCount
=CountDistinct( Fields!Resource_Name.Value , "table1") which gives me a
count of the devices being monitored and reported on ... which is goodness.
However ... I need to display that value in the textbox at the bottom of
the report.
I enter the following expression and get an error
="Total number of devices monitored for this Client:" +
(ReportItems!DeviceCount.Value, "table1")
"MJ Taft" wrote:
> I have a report with one group level where I am hiding detail and only
> showing group totals. This report is summarized/grouped by device (like a
> system name) and I am trying to calc the total number of devices monitored
> which would be equal to the number of groups I have on the report. I have
> tried all the aggregate functions RowNumber(nothing) to count outer most
> level, CountDistinct, RowCount, CountRows ... etc etc and nothing gives me
> what I want. If I were to code it ... I would have some counter that every
> time I created a group footer then I would add 1 to the counter. It seems
> that this should be something simple (and maybe it is!) but the expression I
> am grouping on is a system name (so cant use THAT like a sum). I would do it
> at the database level but I am using a stored procedure so cant modify the
> sql. I tried to create (add) a field (as you would a calculated field or
> database field) but got some error about out of bounds for array or
> something. This is driving me nuts! please help!!!|||Got this one figured out too. Added a footer to report and put it in there.
No problem referencing now using expression:
="Total number of devices monitored for this Client:" &
ReportItems!DeviceCount.Value
I would like to know if there is a way to reference it in the body of the
report without having to use the footer though. Thanks!
"MJ Taft" wrote:
> I got it to work finally. Now the problem is that I want to display the
> device count in a textbox at the end of the report and I get an error trying
> to reference the field I just created in the table portion of the report. In
> the table (called table1 in the report) I entered the following expression
> in the textbox I named DeviceCount
> =CountDistinct( Fields!Resource_Name.Value , "table1") which gives me a
> count of the devices being monitored and reported on ... which is goodness.
> However ... I need to display that value in the textbox at the bottom of
> the report.
> I enter the following expression and get an error
> ="Total number of devices monitored for this Client:" +
> (ReportItems!DeviceCount.Value, "table1")
> "MJ Taft" wrote:
> > I have a report with one group level where I am hiding detail and only
> > showing group totals. This report is summarized/grouped by device (like a
> > system name) and I am trying to calc the total number of devices monitored
> > which would be equal to the number of groups I have on the report. I have
> > tried all the aggregate functions RowNumber(nothing) to count outer most
> > level, CountDistinct, RowCount, CountRows ... etc etc and nothing gives me
> > what I want. If I were to code it ... I would have some counter that every
> > time I created a group footer then I would add 1 to the counter. It seems
> > that this should be something simple (and maybe it is!) but the expression I
> > am grouping on is a system name (so cant use THAT like a sum). I would do it
> > at the database level but I am using a stored procedure so cant modify the
> > sql. I tried to create (add) a field (as you would a calculated field or
> > database field) but got some error about out of bounds for array or
> > something. This is driving me nuts! please help!!!|||Doesn't it work fine when you use the footer of a table instead of the footer
of the report?
"MJ Taft" wrote:
> Got this one figured out too. Added a footer to report and put it in there.
> No problem referencing now using expression:
> ="Total number of devices monitored for this Client:" &
> ReportItems!DeviceCount.Value
> I would like to know if there is a way to reference it in the body of the
> report without having to use the footer though. Thanks!
> "MJ Taft" wrote:
> > I got it to work finally. Now the problem is that I want to display the
> > device count in a textbox at the end of the report and I get an error trying
> > to reference the field I just created in the table portion of the report. In
> > the table (called table1 in the report) I entered the following expression
> > in the textbox I named DeviceCount
> > =CountDistinct( Fields!Resource_Name.Value , "table1") which gives me a
> > count of the devices being monitored and reported on ... which is goodness.
> >
> > However ... I need to display that value in the textbox at the bottom of
> > the report.
> > I enter the following expression and get an error
> >
> > ="Total number of devices monitored for this Client:" +
> > (ReportItems!DeviceCount.Value, "table1")
> >
> > "MJ Taft" wrote:
> >
> > > I have a report with one group level where I am hiding detail and only
> > > showing group totals. This report is summarized/grouped by device (like a
> > > system name) and I am trying to calc the total number of devices monitored
> > > which would be equal to the number of groups I have on the report. I have
> > > tried all the aggregate functions RowNumber(nothing) to count outer most
> > > level, CountDistinct, RowCount, CountRows ... etc etc and nothing gives me
> > > what I want. If I were to code it ... I would have some counter that every
> > > time I created a group footer then I would add 1 to the counter. It seems
> > > that this should be something simple (and maybe it is!) but the expression I
> > > am grouping on is a system name (so cant use THAT like a sum). I would do it
> > > at the database level but I am using a stored procedure so cant modify the
> > > sql. I tried to create (add) a field (as you would a calculated field or
> > > database field) but got some error about out of bounds for array or
> > > something. This is driving me nuts! please help!!!|||I tried that and got this message:
The value expression for the textbox â'textbox7â' refers to the report item
â'DeviceCountâ'. Report item expressions can only refer to other report items
within the same grouping scope or a containing grouping scope.
"David Bienstock" wrote:
> Doesn't it work fine when you use the footer of a table instead of the footer
> of the report?
> "MJ Taft" wrote:
> > Got this one figured out too. Added a footer to report and put it in there.
> > No problem referencing now using expression:
> >
> > ="Total number of devices monitored for this Client:" &
> > ReportItems!DeviceCount.Value
> >
> > I would like to know if there is a way to reference it in the body of the
> > report without having to use the footer though. Thanks!
> >
> > "MJ Taft" wrote:
> >
> > > I got it to work finally. Now the problem is that I want to display the
> > > device count in a textbox at the end of the report and I get an error trying
> > > to reference the field I just created in the table portion of the report. In
> > > the table (called table1 in the report) I entered the following expression
> > > in the textbox I named DeviceCount
> > > =CountDistinct( Fields!Resource_Name.Value , "table1") which gives me a
> > > count of the devices being monitored and reported on ... which is goodness.
> > >
> > > However ... I need to display that value in the textbox at the bottom of
> > > the report.
> > > I enter the following expression and get an error
> > >
> > > ="Total number of devices monitored for this Client:" +
> > > (ReportItems!DeviceCount.Value, "table1")
> > >
> > > "MJ Taft" wrote:
> > >
> > > > I have a report with one group level where I am hiding detail and only
> > > > showing group totals. This report is summarized/grouped by device (like a
> > > > system name) and I am trying to calc the total number of devices monitored
> > > > which would be equal to the number of groups I have on the report. I have
> > > > tried all the aggregate functions RowNumber(nothing) to count outer most
> > > > level, CountDistinct, RowCount, CountRows ... etc etc and nothing gives me
> > > > what I want. If I were to code it ... I would have some counter that every
> > > > time I created a group footer then I would add 1 to the counter. It seems
> > > > that this should be something simple (and maybe it is!) but the expression I
> > > > am grouping on is a system name (so cant use THAT like a sum). I would do it
> > > > at the database level but I am using a stored procedure so cant modify the
> > > > sql. I tried to create (add) a field (as you would a calculated field or
> > > > database field) but got some error about out of bounds for array or
> > > > something. This is driving me nuts! please help!!!|||You need to put a countrows(groupname) in the group footer. First, you need
to assigne a name to your group, then use that name in the countrows function.
Best of luck!
"MJ Taft" wrote:
> I have a report with one group level where I am hiding detail and only
> showing group totals. This report is summarized/grouped by device (like a
> system name) and I am trying to calc the total number of devices monitored
> which would be equal to the number of groups I have on the report. I have
> tried all the aggregate functions RowNumber(nothing) to count outer most
> level, CountDistinct, RowCount, CountRows ... etc etc and nothing gives me
> what I want. If I were to code it ... I would have some counter that every
> time I created a group footer then I would add 1 to the counter. It seems
> that this should be something simple (and maybe it is!) but the expression I
> am grouping on is a system name (so cant use THAT like a sum). I would do it
> at the database level but I am using a stored procedure so cant modify the
> sql. I tried to create (add) a field (as you would a calculated field or
> database field) but got some error about out of bounds for array or
> something. This is driving me nuts! please help!!!