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
kaOn 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