suppressing items

[sumeet22]

Have a scenario as follows and I am using this as sub report.

id item a item b item c item d
-- ------ ------ ------ ------
1 good xyz nnn VVV
1 good xyz nnn PPP
1 good xyz nnn QQQ
1 bad abc kkk VVV
1 bad abc kkk PPP
1 bad abc kkk QQQ

given the above records from a stored proc, I have to group by item a, which gives me 2 distict groups. the prob is item d is the same for both group types. I want item d to appear just once and not twice.

The result I want is:

good
xyz nnn
bad
abc kkk

PPP
QQQ
VVV

item d should appear as above at the end of the sub report.


Help.

 

[kskid]

Not enough technical information.

Where is the subreport in the main report? How is it linked?

I am assuming the main report is grouped by id

Based on the sample data you supplied,

[ol][li]In the subreport, remove item d[/li]
[li]In the main report, insert a section under the section containing the subreport[/li]
[li]save subreport as subreport_1
[li]Insert subreport_1 in the section using the same link as your original subreport[/li]
[li]Edit the subreport_1 and change the group from item a to item d.[/li][/ol]

Cheers,
-LW

 

[sumeet22]

Thanks dude, it helped !!