Reporting Services Groups

Iâ'm somewhat new to Reporting Services. I have a report that uses a stored
procedure â?¦problem Iâ'm having is using the Groups to sort the parent and
child data correctly.
The data looks like this:
Parent ID Child ID Date Comment
1 0 10/1/2004 â'Parent comment 1â'
2 1 10/2/2004 â'child comment 1â'
3 1 10/3/2004 â'child comment 2â'
4 0 10/3/2004 â'Parent comment 2â'
5 4 10/4/2004 â'child comment 1â'
I want the report grouped like this:
Parent comment 1 10/1/2004
child comment 1 10/2/2004
child comment 2 10/3/2004
Parent comment 2 10/3/2004
child comment 1 10/4/2004
Any help is much appreciated.
Thanks
--
sandersonPlease read this section in RS BOL about "Recursive Hierarchies":
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_structure_objects_v1_3cok.asp
The important part is the "Parent" property on groupings.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"sanderson" <sanderson@.discussions.microsoft.com> wrote in message
news:BFF955C8-6A25-4C81-B087-1F28645302AC@.microsoft.com...
> I'm somewhat new to Reporting Services. I have a report that uses a
stored
> procedure .problem I'm having is using the Groups to sort the parent and
> child data correctly.
> The data looks like this:
> Parent ID Child ID Date Comment
> 1 0 10/1/2004 "Parent comment 1"
> 2 1 10/2/2004 "child comment 1"
> 3 1 10/3/2004 "child comment 2"
> 4 0 10/3/2004 "Parent comment 2"
> 5 4 10/4/2004 "child comment 1"
>
> I want the report grouped like this:
> Parent comment 1 10/1/2004
> child comment 1 10/2/2004
> child comment 2 10/3/2004
>
> Parent comment 2 10/3/2004
> child comment 1 10/4/2004
>
> Any help is much appreciated.
> Thanks
> --
> sanderson|||I read the section and did exactly the same... however i always get
this warning message.
"Build complete -- 0 errors, 0 warnings
The group expression expression used in grouping
'table1_Details_Group' returned a data type that is not valid.
Preview complete -- 0 errors, 1 warnings"
And it returned only one row of record.
I have a productcategory table which is recursive. A category can have
subcategories and also belongs to a parent category. My parent category
has null value which indicate the top-most level i.e. the parent.
Even if i include "...where parentcategoryid is not null" , it will
still display the message.
May i know why? And how do I correct this error...and get it to display
accordingly.
I started using Reporting Service 2-3 months ago.
I would really appreciate if someone could assist me on this.
Thanks in advance.|||Hi I too got the same warning, the field that I used in the grouping is a unique identifier (ProjectID). When I replace it with ProjectName, it worked without any warning.
However, I want to use the ID rather that the name as the IDs are Unique but names need not be.
Any help is appreciated.
-Srinivas
From http://www.google.com/search?hl=en&q="The+group+expression+expression+used+in+grouping"+"returned+a+data+type+that+is+not+valid
Posted via DevelopmentNow.com Group
http://www.developmentnow.com