Author Topic: Projecting Awards  (Read 5474 times)

MaureenCooper

  • Full Member
  • ***
  • Posts: 39
    • Tri-City Awana Clubs
Projecting Awards
« on: February 21, 2016, 06:01:56 PM »
Note: This post was originally for the Legacy database, but applies to the Cloud database's Windows App as well.

Could a SQL be written to give me a simple report for forecasting projected book awards?  I would need: Club Name, Clubber Name, Grade, Handbook, Award to be earned.  I've been using the Clubber Status report and export to Excel and then delete columns I don't need and all the text boxes.  I print that report out and highlight when I've ordered the awards for those clubbers.
« Last Edit: March 24, 2022, 11:25:45 AM by Annette »
Maureen Cooper
Commander
Tri-City Church, Vista CA

roscom

  • Full Member
  • ***
  • Posts: 23
    • Awana@Gold Country Baptist Church
Re: Projecting Awards
« Reply #1 on: April 19, 2017, 08:59:30 AM »
I know that this is over 1 year old, but am wondering if you know that the summary option of the Current Handbook status report projects the awards for you. 

Rick just last week added an enhancement to that report to show the data behind it once you "preview" or "print" the report.  You can hide columns you don't need and filter or sort the data however you want it.

If you check for updates you will get the latest build with that enhancement in it.

[Note: This feature was also added to the Windows App.]
« Last Edit: March 10, 2022, 11:59:41 AM by Annette »
Maureen Roscorla
Administrator
Awana@Gold Country Baptist Church