Sorting people in multiple activities
Moderators: Moderators, Tech Support
Sorting people in multiple activities
We have Activities and Skills codes for both Sunday School Classes and Small Groups. I'm trying to produce a report of just those who are members of both a Sunday School Class and a Small Group. I can run a custom report and get all those in Sunday School and run another report and get all those in Small Groups, but when I run the report using the same queries with "and" as the connector PC tells me that there are no records matching the description. What am I doing wrong?
pdawg
Re: Sorting people in multiple activities
I'm trying to remember if this type of query can be constructed using the current report writer. I'm fairly sure it can't be done since it requires an inner join which basically returns only the records that satisfy the two queries. (IE: is in Activity 1 and and in Activity 2).
Here's a definition of an inner join: http://en.wikipedia.org/wiki/Outer_join#Inner_join
Here's a definition of an inner join: http://en.wikipedia.org/wiki/Outer_join#Inner_join
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.
-
- Tech Support
- Posts: 3006
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Sorting people in multiple activities
This is correct. You could query for activity=1 AND activity=2, but it would return zero results, since no single record in the activities database meets both conditions. If you use the OR connector, you will get everyone that is a member of one or the other or both.
If you do it that way, you could do the following:
In the output fields, make sure that "last, first" and "skill number" are included.
- Group first on "last, first"
- Count the skill number field
In the report form, enter "cnt_skill_no>=2" in the Print When for each of the output fields.
It's a bit of a hack, but it will do what you want!
If you do it that way, you could do the following:
In the output fields, make sure that "last, first" and "skill number" are included.
- Group first on "last, first"
- Count the skill number field
In the report form, enter "cnt_skill_no>=2" in the Print When for each of the output fields.
It's a bit of a hack, but it will do what you want!