I need some general info (where to look?) or any tips & tricks.
I have a report in CR8.5 with an Oracle backend. I'm using 4 subreports within the report; so, to get my dataset smaller (+100K records/month), I am using the Crystal SQL Designer to create qry files. This works OK, however, I need to run the reports once/month using the data from the previous month.
How do I automate the report generation on:
1) the SQL queries (the dates need to change each month).
2) the monthly reports.
I would like the reports to kick off automatically sometime after the 1st of the next month. I have access to VB, but it's been a long time since I used it.
I've looked for subjects like this in this forum, in help & in my Complete Reference book, but have not seen anything that is like what I want to do. Am I off base? Is there another way to go about this?
I have a report in CR8.5 with an Oracle backend. I'm using 4 subreports within the report; so, to get my dataset smaller (+100K records/month), I am using the Crystal SQL Designer to create qry files. This works OK, however, I need to run the reports once/month using the data from the previous month.
How do I automate the report generation on:
1) the SQL queries (the dates need to change each month).
2) the monthly reports.
I would like the reports to kick off automatically sometime after the 1st of the next month. I have access to VB, but it's been a long time since I used it.
I've looked for subjects like this in this forum, in help & in my Complete Reference book, but have not seen anything that is like what I want to do. Am I off base? Is there another way to go about this?