Multiple Query Help

[JKas]

Hello,

I am using Cognos ReportNet 1.1 and need some help. I am trying to create a report using the following requirements:

-A list of people that are in a membership association.
-The data includes membership status (a=active, e=expired)
-The data include membership expiration date.
- I want only the people whose membership expired AND do not have a new membership with an active status.

Here was my approach:
-Using a Tabular Set with Tab Model1 (left side) where Status = E. Tab Model2 (right side) where Status=A. -Instead of the union, using the Except.
-The dates are set-up as parameters, so the client can entered for any time period.

Here is my problem:
I seem to be missing the final link of being able to select the items for display in the report.

Is this approach valid? Am I missing just a few things, or am I way off?

Thanks

p.s. I am a Business Analyst new to actual programming (in case you can't tell )

 

[JKas]

I think I may have found a solution:

I created a query with all my need fields (including date parameters).

I then added a child Model (Expired) and set the filter to where member status=E.

I then added a second child model (Active) to the query and set the filter to where member status =A.

I then added another filter in the main query to where member ID (Expired) <> Member ID (Active).

This method has validated, but is taking forever to run.

I guess I'm still looking at which approach would be the most efficient. Any suggestions would be appreciated.

Thanks