Exclude items from subreport based on main report

[maas]

Hello All,

I need your assistant in getting the appropriate way to exclude some of the items from the subreport based on the items that are passed from the main report and to show the extra items which are in the subreport. What I mean is that I am having a main report that is displaying the deal numbers and some descriptions which belongs to each deal. Also, the subreport is having the same fields which are the deal numbers and some descriptions.I want the subreport to exclude the deal numbers which are displayed in the main report and and to show the extra deal numbers which are in the subreport.

My report structure is:

Group Header #1: Security Group Name (Bond/Treasury)

Group Header #2: Security Code Reference (XXY/AAAA/BBB)

Group Header #3: Deal No

Detail: Deal No, Amount, Effective Date

Group Footer #1:

Group Footer #2:

Group Footer #3:

The subreport is having the same structure and I placed it in the Group Header #2.

I added a subreport link which is a parameter for the deal no from the main report to be passed to the subreport. And in the subreport I defined {Command.deal_no} <> {?PM-Deal_no}in the select expert. However, the extra deals are not coming.

Can you please assist me in this issue

 

[BettyJ]

I feel this may help you in some way. Please check thread767-1720758