Search results for query: *

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

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".

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...

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...

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.

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.