I'm relatively inexperienced with Reportsmith and I'm trying to develop a report where it will only list those active employees that have not received a check since 10/1/09. Everything I try lists all employees.
This is an example of a style of report I call the “everyone that’s not here raise your hand” report. Here is how I would look at it:
1.) Create a report that has the very basic info in it for all active employees.
2.) What if you could get rid of the people that have had a check by typing in their Emplid? You would have a Selection Criteria something like Emplid is not in List of Values. And in the values editor you would type in every Emplid. That would be a big pain in the you know what.
a. Save this report and create another report that ONLY, ONLY, ONLY returns the Emplids of people who HAVE had a check in your time frame. This report needs to be as simple as possible. No sorting or anything.
b. Copy the SQL from report 2.a
c. Open report from 1
d. Edit your list Criteria from Of Values to Formula
e. In the Formula editor type in () and then paste your SQL from 2b between the (). This will generate your list of people to exclude.
Thank you soooo much for your help! It would have taken me three lifetimes to come up with that! I'm having a slight problem though. When I go into the Selection Criteria and change the criteria from data field to formula, it wants another field. It says "formula _____ is equal to text ____." What should I use for the second field?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.