"Problem": When doing reports, I have to manually export like 50 reports based on some dates depending on the kind of report (monthly, quarterly).
Question: Is there any way to make this automatic? Like I press a button or run a script that generates the reports on their given dates, then automatically exports this to some folder as an excel file?
Thanks for all your inputs.
Scheduling tools - Crystal's own scheduling tool for Crystal Reports X was called Crystal Enterprise. They often included this free with Crystal Reports, but only licensed for relatively small numbers of users.
If your company already has Crystal Enterprise and the licensing permits it, I suggest using that. (I'm not sure whether Crystal/BO/whoever they are now will still sell Crystal Enterprise 10; even if they do, the licensing may be prohibitively expensive.)
Alternatively, consider third party scheduling tools, or even writing your own.
I'm a big fan of Visual Cut (http://www.milletsoftware.com/Visual_CUT.htm). This little package has a command line interface for generating and exporting .rpt files, including burst reports (i.e. 1 file per level 1 group). I use this all the time for automation. If you have several .rpt files you need processed, then you can just put all your command lines into a single batch file and you'll have the 1-button nirvana you seek :)
The author is also very responsive if you get the annual support. Every single time I've sent him a question, he emails or calls back within the day.