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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Ray M
  • Order by date
  1. Ray M

    Time In Care

    I had the syntax wrong in the incare formula. Thank you for your patience. Have an awesome day!
  2. Ray M

    Time In Care

    I just ran into a situation where an animal was in foster (3) separate times before being adopted. It's the date math on multiple intakes that is tripping me up. The time in care tallying would end when the outcome type is "adoption".
  3. Ray M

    Time In Care

    Intake date, intake type, outcome date, outcome type (all in one kennel impound record) Intake date, intake type, outcome date, outcome type (all in a 2nd kennel impound record) - the 2nd kennel impound record is generated when the animal comes back from the original outcome for example: dog a...
  4. Ray M

    Time In Care

    I don't know if this will make sense to folks. I work for an animal shelter and the software we use tracks an animal's impound and outcome (the outcome is usually Adoption but can vary.) My issue is I need to track an animal's time in care (or the time it either spent at our shelter or in one...
  5. Ray M

    Database logged in user

    I tried the CEUser but it diddn't work. I may have figured it out though. I added a SQL Expression with "{fn USER()}" (without the quotes) and it seems to have worked when I used it in the Section Expert's Conditional Suppress.
  6. Ray M

    Database logged in user

    I am trying to limit a Crystal Reports use to only certain users. I need to be able to acquire the current logged in SQL user so I can conditionally suppress a subreport so that userA and userB can see it but not userC.

Part and Inventory Search

Back
Top