Options for export?

I've been looking for the same thing since we migrated to LBI from CE. I just want to export a pdf file to a file share on a daily basis (something CE was able to accomplish rather easily).

You can schedule a Crystal Report to run on CE and have the output saved to a specific destination in a specified format. The destination and format are all specified when you schedule the report on CE. We have several running each evening that produce outputs of .pdf, .xls, .csv and even printed versions.

We faced a similar challange and found that LBI scheduled reports cannot be configured to publish to a static location. This was a problem for us since each time the report ran it went a new historical instance folder. What we ended up doing was to write a custom sql query to read the LBI tables and generate a script to copy the files to where we wanted them. We run this daily and it determines what reports ran in the last 24 hours and what historical instance folder the output is located in. Then it generates and executes the code to perform the copy. All the information required to accomplish this is in about 3 or 4 Lawson tables but the fun part was figuring it out.

Would you be able to share your SQL?