Currently, I have a report scheduled to run several times a day with excel as its output format. I must have the "lite" version of Enterprise so I can't tell Crystal to email the report or save it somewhere. But what I did notice is that the excel file generated is being saved in randomly named "output" directory on the Server. There are literally more than a hundred of these directories where scheduled files are saved until their history is removed. So, my question is: Is there anyway to tell Crystal Enterprise where to save the scheduled output file. I am currently using a VB program to find the randomly saved; randomly place excel file (it looks something like this \A1212\~ce2323232323.xls) . Once the file is found, it is renamed and moved to another folder. I'd really like to be able to just have a single folder that the scheduled files will be saved to. It would make things so much easier. Any help is greatly appreciated!
-K
-K