1 Reply Latest reply on Mar 21, 2009 10:05 AM by comment_1

    Report record exclusion needed

    synergy46

      Title

      Report record exclusion needed

      Post

      I have 2 tables:

       

      Members:

         MemberID.pk

         MemberName

         Status (text) -- Holds values like: "Deceased" "Active" etc...

       

      Proficiencies:

         MemberID.fk

         Proficiency:  -- holds values like:  "programming" "accounting"  etc.

       

      I have created a sub summary report grouped and sorted on Proficiency.  It works.  But it also includes members who have a status of "Deceased". (not desired)

       

      Do I need to first perform a 'find' on a subset of the data where Members::Status <> "Deceased".... ???

       

      Your thoughts are appreciated.

       

       

        • 1. Re: Report record exclusion needed
          comment_1
            

          I'd suggest you start by finding the members you want to report on, in the Members table e.g.

           

          Go to Layout [ Members ]

          Perform Find [Restore; Omit Records; Criteria: Members::Status: “Deceased" ]

           

           

          Then use the Go to Related Record [ Show related only; Match found set ] step to create the found set in Proficiencies.