index | search | no replies | posting guidelines | help | login | register |
Index » General » ASP Report Feedback |
| |||||||
Sep 11 2004, 4:33 PM |
| ||||||
jifland from: Tampa, FL | Hi, Users are loving your product. Hope you don't mind the suggestions for enhancements. A valuable enhancement would be to be able to set a filter where the Value is "equal to the field Max" or "equal to the field Min" value in the current record set. The following SQL is the basic logic of what we're needing to do in the report. select * from DataLoad_Exceptions t where t.processdate = (Select Max(ProcessDate) From DataLoad_Exceptions)) An actual example of where this code is used is where we log/append all exceptions generated from many/all data loads into a single table. The frequency of the data loads vary. We never delete the records because they have historical value, but we only want to report on the exceptions generated during the last data load. This feature/enhancement is needed because this type of filter criteria can not be stored as a static character string. Let me know what you think. Thanks, Jeff | ||||||
Pages: (1) [1] |