count property on group?

Is there any way to show the count of a collapsed group on the row set to
toggle visibility. For example, if I have rows for Purchase Orders and
grouped under that, rows for line detail that are hidden with Purcharse
Orders number as the toggle textbox, is there some way to show the detail
line count on the Purchase Order row? That is, short of establishing a
dataset?
--
Thanks,
CGWjust a thought, create a parameter and set it equal to the the line detail
row count and display the parameter for every purchase order.
"CGW" <CGW@.discussions.microsoft.com> wrote in message
news:CDE25805-C0F8-41B6-A4E1-9CA4F2C0EFA0@.microsoft.com...
> Is there any way to show the count of a collapsed group on the row set to
> toggle visibility. For example, if I have rows for Purchase Orders and
> grouped under that, rows for line detail that are hidden with Purcharse
> Orders number as the toggle textbox, is there some way to show the detail
> line count on the Purchase Order row? That is, short of establishing a
> dataset?
> --
> Thanks,
> CGW|||I'm used to setting paramater values with either a constant or a query (as in
dataset). How would the expression look? And if the count is some property I
can have with a parameter, could I not also have it for the group and/or
detail row count? I'm sorry, but I'm still new to a bit of this. If you could
give me just a little more clarification, it would really help.
Thanks
"Vaibhav" wrote:
> just a thought, create a parameter and set it equal to the the line detail
> row count and display the parameter for every purchase order.
> "CGW" <CGW@.discussions.microsoft.com> wrote in message
> news:CDE25805-C0F8-41B6-A4E1-9CA4F2C0EFA0@.microsoft.com...
> > Is there any way to show the count of a collapsed group on the row set to
> > toggle visibility. For example, if I have rows for Purchase Orders and
> > grouped under that, rows for line detail that are hidden with Purcharse
> > Orders number as the toggle textbox, is there some way to show the detail
> > line count on the Purchase Order row? That is, short of establishing a
> > dataset?
> > --
> > Thanks,
> >
> > CGW
>
>|||I am assuming that to retrieve the line details you are passing purchase
order to the details dataset. In the retireved dataset along with the other
columns add one more column with row count and then set the parameter equal
to the column value for the dataset.and display paramter.value for every
PO(line details count).
"CGW" <CGW@.discussions.microsoft.com> wrote in message
news:88F8172F-58C3-46B9-B691-AAFD48AD9D9D@.microsoft.com...
> I'm used to setting paramater values with either a constant or a query (as
> in
> dataset). How would the expression look? And if the count is some property
> I
> can have with a parameter, could I not also have it for the group and/or
> detail row count? I'm sorry, but I'm still new to a bit of this. If you
> could
> give me just a little more clarification, it would really help.
> Thanks
> "Vaibhav" wrote:
>> just a thought, create a parameter and set it equal to the the line
>> detail
>> row count and display the parameter for every purchase order.
>> "CGW" <CGW@.discussions.microsoft.com> wrote in message
>> news:CDE25805-C0F8-41B6-A4E1-9CA4F2C0EFA0@.microsoft.com...
>> > Is there any way to show the count of a collapsed group on the row set
>> > to
>> > toggle visibility. For example, if I have rows for Purchase Orders and
>> > grouped under that, rows for line detail that are hidden with Purcharse
>> > Orders number as the toggle textbox, is there some way to show the
>> > detail
>> > line count on the Purchase Order row? That is, short of establishing a
>> > dataset?
>> > --
>> > Thanks,
>> >
>> > CGW
>>|||The dataset query returns both Purchase Order and Detail information with
grouping done at the report level. To put a count for PO detail in is
possible, but would require additional querying. I suppose I was just hoping
that SQL Reporting might have a property on groups, or something like that,
which could be used. Thank you.
"Vaibhav" wrote:
> I am assuming that to retrieve the line details you are passing purchase
> order to the details dataset. In the retireved dataset along with the other
> columns add one more column with row count and then set the parameter equal
> to the column value for the dataset.and display paramter.value for every
> PO(line details count).
> "CGW" <CGW@.discussions.microsoft.com> wrote in message
> news:88F8172F-58C3-46B9-B691-AAFD48AD9D9D@.microsoft.com...
> > I'm used to setting paramater values with either a constant or a query (as
> > in
> > dataset). How would the expression look? And if the count is some property
> > I
> > can have with a parameter, could I not also have it for the group and/or
> > detail row count? I'm sorry, but I'm still new to a bit of this. If you
> > could
> > give me just a little more clarification, it would really help.
> >
> > Thanks
> >
> > "Vaibhav" wrote:
> >
> >> just a thought, create a parameter and set it equal to the the line
> >> detail
> >> row count and display the parameter for every purchase order.
> >>
> >> "CGW" <CGW@.discussions.microsoft.com> wrote in message
> >> news:CDE25805-C0F8-41B6-A4E1-9CA4F2C0EFA0@.microsoft.com...
> >> > Is there any way to show the count of a collapsed group on the row set
> >> > to
> >> > toggle visibility. For example, if I have rows for Purchase Orders and
> >> > grouped under that, rows for line detail that are hidden with Purcharse
> >> > Orders number as the toggle textbox, is there some way to show the
> >> > detail
> >> > line count on the Purchase Order row? That is, short of establishing a
> >> > dataset?
> >> > --
> >> > Thanks,
> >> >
> >> > CGW
> >>
> >>
> >>
>
>|||You should be able to to do this thru the Count aggregation. Try
"=Count(Fields.MyField.Value)". This does require that the Purchase Order is
an actual group within the table.
"CGW" wrote:
> The dataset query returns both Purchase Order and Detail information with
> grouping done at the report level. To put a count for PO detail in is
> possible, but would require additional querying. I suppose I was just hoping
> that SQL Reporting might have a property on groups, or something like that,
> which could be used. Thank you.
> "Vaibhav" wrote:
> > I am assuming that to retrieve the line details you are passing purchase
> > order to the details dataset. In the retireved dataset along with the other
> > columns add one more column with row count and then set the parameter equal
> > to the column value for the dataset.and display paramter.value for every
> > PO(line details count).
> >
> > "CGW" <CGW@.discussions.microsoft.com> wrote in message
> > news:88F8172F-58C3-46B9-B691-AAFD48AD9D9D@.microsoft.com...
> > > I'm used to setting paramater values with either a constant or a query (as
> > > in
> > > dataset). How would the expression look? And if the count is some property
> > > I
> > > can have with a parameter, could I not also have it for the group and/or
> > > detail row count? I'm sorry, but I'm still new to a bit of this. If you
> > > could
> > > give me just a little more clarification, it would really help.
> > >
> > > Thanks
> > >
> > > "Vaibhav" wrote:
> > >
> > >> just a thought, create a parameter and set it equal to the the line
> > >> detail
> > >> row count and display the parameter for every purchase order.
> > >>
> > >> "CGW" <CGW@.discussions.microsoft.com> wrote in message
> > >> news:CDE25805-C0F8-41B6-A4E1-9CA4F2C0EFA0@.microsoft.com...
> > >> > Is there any way to show the count of a collapsed group on the row set
> > >> > to
> > >> > toggle visibility. For example, if I have rows for Purchase Orders and
> > >> > grouped under that, rows for line detail that are hidden with Purcharse
> > >> > Orders number as the toggle textbox, is there some way to show the
> > >> > detail
> > >> > line count on the Purchase Order row? That is, short of establishing a
> > >> > dataset?
> > >> > --
> > >> > Thanks,
> > >> >
> > >> > CGW
> > >>
> > >>
> > >>
> >
> >
> >|||Funny, I thought I had tried that. It works great now!!! Thanks!
"John W" wrote:
> You should be able to to do this thru the Count aggregation. Try
> "=Count(Fields.MyField.Value)". This does require that the Purchase Order is
> an actual group within the table.
> "CGW" wrote:
> > The dataset query returns both Purchase Order and Detail information with
> > grouping done at the report level. To put a count for PO detail in is
> > possible, but would require additional querying. I suppose I was just hoping
> > that SQL Reporting might have a property on groups, or something like that,
> > which could be used. Thank you.
> >
> > "Vaibhav" wrote:
> >
> > > I am assuming that to retrieve the line details you are passing purchase
> > > order to the details dataset. In the retireved dataset along with the other
> > > columns add one more column with row count and then set the parameter equal
> > > to the column value for the dataset.and display paramter.value for every
> > > PO(line details count).
> > >
> > > "CGW" <CGW@.discussions.microsoft.com> wrote in message
> > > news:88F8172F-58C3-46B9-B691-AAFD48AD9D9D@.microsoft.com...
> > > > I'm used to setting paramater values with either a constant or a query (as
> > > > in
> > > > dataset). How would the expression look? And if the count is some property
> > > > I
> > > > can have with a parameter, could I not also have it for the group and/or
> > > > detail row count? I'm sorry, but I'm still new to a bit of this. If you
> > > > could
> > > > give me just a little more clarification, it would really help.
> > > >
> > > > Thanks
> > > >
> > > > "Vaibhav" wrote:
> > > >
> > > >> just a thought, create a parameter and set it equal to the the line
> > > >> detail
> > > >> row count and display the parameter for every purchase order.
> > > >>
> > > >> "CGW" <CGW@.discussions.microsoft.com> wrote in message
> > > >> news:CDE25805-C0F8-41B6-A4E1-9CA4F2C0EFA0@.microsoft.com...
> > > >> > Is there any way to show the count of a collapsed group on the row set
> > > >> > to
> > > >> > toggle visibility. For example, if I have rows for Purchase Orders and
> > > >> > grouped under that, rows for line detail that are hidden with Purcharse
> > > >> > Orders number as the toggle textbox, is there some way to show the
> > > >> > detail
> > > >> > line count on the Purchase Order row? That is, short of establishing a
> > > >> > dataset?
> > > >> > --
> > > >> > Thanks,
> > > >> >
> > > >> > CGW
> > > >>
> > > >>
> > > >>
> > >
> > >
> > >