Approved Workman Database

Community Contributions => Q&A => Topic started by: MaureenCooper on February 21, 2016, 06:01:56 PM

Title: Projecting Awards
Post by: MaureenCooper 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.
Title: Re: Projecting Awards
Post by: roscom 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.]