Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Reportsmith Question 1
- Thread starter haeddy
- Start date
-
1
- #2
CharlesCook
Programmer
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.
This should give you what you need.
Specializing in ReportSmith Training and Consulting
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.
This should give you what you need.
Specializing in ReportSmith Training and Consulting
- Thread starter
- #3
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?
I'm using Reportsmith 3.1 if that helps.
I'm using Reportsmith 3.1 if that helps.
CharlesCook
Programmer
You don't change the "data field" part. You change the "of values" part.
"Data Field Emplid Is NOT in list Of Values Values"
CHANGE TO
"Data Field Emplid Is NOT in List Formula _______"
AND
"Data Field Emplid Is NOT in List Formula PUT YOUR COPIED SQL IN HERE"
Specializing in ReportSmith Training and Consulting
"Data Field Emplid Is NOT in list Of Values Values"
CHANGE TO
"Data Field Emplid Is NOT in List Formula _______"
AND
"Data Field Emplid Is NOT in List Formula PUT YOUR COPIED SQL IN HERE"
Specializing in ReportSmith Training and Consulting
- Thread starter
- #5
CharlesCook
Programmer
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question