How do automate a report to query records for a specific time interval?
How do automate a report to query records for a specific time interval?
(OP)
How do you automate a report to query records for a specific time interval?
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you a
Computer / IT professional? Join Tek-Tips Forums!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
How do automate a report to query records for a specific time interval?
|
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.
RE: How do automate a report to query records for a specific time interval?
2. If you don't want to use SQL expressions and you don't have subreports you can create a shell report and add your report as a subreport. Obviously, your report should have some parameters for from-to. You can set those parameters with Crystal formulas created in the shell report.
3. If you have subreport you can create formulas and use them in the record selection formula. This will be slow since Crystal will download all the data and will filter it locally. Use this method if your tables are small and you do not expect to grow.
4. If you are going to automate the report most likely you are going to use some software to run it. Use the software to calculate and set the parameters' values. If you are looking for such software, please review this document for some basic options: http://r-tag.com/Content/Documents/R-TagFormulas.p... including relative dates like from yesterday 4:00 PM to today 2:00 AM. These options are supported by our free edition available here: http://r-tag.com/Pages/CommunityEdition.aspx
www.R-Tag.com Viewer and Scheduler for Crystal reports, SSRS and Dynamic Dashboards.