SQL Keys

This all seems very well, but what happens if you want to create a custom report that needs to request specific information from the user before running - eg: To filter between two dates, or only show animals of a particular species, etc?

ASM offers SQL preprocessor instructions to allow you to substitute system information, or information requested from the user at report generation time.

http://sheltermanager.sf.net