Author Topic: report to show all clubbers missing Red 1:1?  (Read 1955 times)

kriswilkinson

  • Jr. Member
  • **
  • Posts: 11
report to show all clubbers missing Red 1:1?
« on: April 06, 2012, 03:48:08 PM »
In our club, Red 1:1 is the only section we allow clubbers to skip and come back to at some point within the club year.  Red 1:1 is Bring a Visitor to Club.  Is there a way to run a report to find all clubbers who have not completed Red 1:1? 

Thanks,
Kris

Rick Leffler

  • Administrator
  • Sr. Member
  • *****
  • Posts: 339
    • Approved Workman
Re: report to show all clubbers missing Red 1:1?
« Reply #1 on: April 12, 2012, 02:27:55 PM »
I'll see if I can come up with an SQL statement for you and post it here.
Rick at Leffler Systems
Murfreesboro, Tennessee

kriswilkinson

  • Jr. Member
  • **
  • Posts: 11
Re: report to show all clubbers missing Red 1:1?
« Reply #2 on: May 20, 2012, 07:01:23 PM »
I'll see if I can come up with an SQL statement for you and post it here.

Any updates on the SQL statement?

Many thanks,
Kris

Bernard

  • Newbie
  • *
  • Posts: 2
Re: report to show all clubbers missing Red 1:1?
« Reply #3 on: October 12, 2012, 08:45:20 PM »
Try this:

select Filing_Name  from  section S join person  P on S.Person_ID=P.Person_ID where
S.section_name = 'Red Jewel 1:1' and S.Completed = 'No' and P.Status = 'Active' order
by Filing_Name

Rick Leffler

  • Administrator
  • Sr. Member
  • *****
  • Posts: 339
    • Approved Workman
Re: report to show all clubbers missing Red 1:1?
« Reply #4 on: October 16, 2012, 11:12:09 AM »
Thanks Bernard!
(This was originally posted in April. I clearly overlooked responding to this, sorry.)
Rick at Leffler Systems
Murfreesboro, Tennessee