how to do grouping

how to get report like this, I am using RS2005


From Query I am getting following data


Name,Catageory,ItemcODE,ItemQty

A CAT1 1 1
A CAT1 2 20
A CAT1 3 15
A CAT1 4 2
A CAT1 5 11
B CAT2 1 18
B CAT2 2 20
B CAT2 3 22
C CAT3 1 0
C CAT3 2 32




For above dataset I want to have report like this





Name : A
Catagoery : CAT1
Item Qty
1 1
2 20
and so on


Name : B
Catagoery : CAT2
Item Qty
1 18
2 20
and so on



Name : C
Catagoery : CAT3
Item Qty
1 0
2 32
and so on





i am new to reporting server 2005,

On table, I inserted a Group on Categoery
and again another group on Items


i am getting only one row for each Item,

where i am doing mistake or Is there anyway to todo,




thanks
ka

EMartinez
Fri Nov 30 20:22:40 PST 2007

On Nov 30, 3:06 pm, Kalyan <Kal...@discussions.microsoft.com> wrote:
> how to get report like this, I am using RS2005
>
> From Query I am getting following data
>
> Name,Catageory,ItemcODE,ItemQty
>
> A CAT1 1 1
> A CAT1 2 20
> A CAT1 3 15
> A CAT1 4 2
> A CAT1 5 11
> B CAT2 1 18
> B CAT2 2 20
> B CAT2 3 22
> C CAT3 1 0
> C CAT3 2 32
>
> For above dataset I want to have report like this
>
> Name : A
> Catagoery : CAT1
> Item Qty
> 1 1
> 2 20
> and so on
>
> Name : B
> Catagoery : CAT2
> Item Qty
> 1 18
> 2 20
> and so on
>
> Name : C
> Catagoery : CAT3
> Item Qty
> 1 0
> 2 32
> and so on
>
> i am new to reporting server 2005,
>
> On table, I inserted a Group on Categoery
> and again another group on Items
>
> i am getting only one row for each Item,
>
> where i am doing mistake or Is there anyway to todo,
>
> thanks
> ka


You will want to create a group on Name and then another one on
Category (via: right-clicking the top-left corner of the table control
>> select Properties >> select the Groups tab >> select the 'Add...'
button >> Enter a Name and below 'Group on: Expression' select: Fields!
Name.Value >> then select 'Include group header'). Then for the group
on Category, do the same thing except set the 'Group on: Expression'
to Fields!Category.Value. Then below 'Parent group' select the
expression: Fields!Name.Value. You might need to put the same
expressions in the new group rows that have been added in the table
control. Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant