×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Reportsmith Question

Reportsmith Question

Reportsmith Question

(OP)
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.  

Does anyone have any ideas?

RE: Reportsmith Question

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.
 

http://CharlesCook.com
Specializing in ReportSmith Training and Consulting

RE: Reportsmith Question

(OP)
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.

RE: Reportsmith Question

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"   

http://CharlesCook.com
Specializing in ReportSmith Training and Consulting

RE: Reportsmith Question

(OP)
It worked!!  You're wonderful!!  Thank you soooooo much!!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close